Numerics
- 32-bit IEEE 754 format 1
- 64-bit IEEE 754 format 1
A
- Abstract Data Type (ADT) 1
- native floating-point data types in 1
- resetting evolved 1
- ACCESSIBLE BY clause
- in package specification 1
- stored subprogram and 1
- actualization 1
- actual object 1
- ADDM (Automatic Database Diagnostic Monitor) 1
- address of row (rowid) 1
- administrators, restricting with Oracle Database Vault 1
- ADT
- See: Abstract Data Type (ADT)
- AFTER SUSPEND trigger 1
- agent 1
- aggregate function 1
- ALL_ARGUMENTS 1
- ALL_DEPENDENCIES 1
- ALL_ERRORS 1
- ALL_IDENTIFIERS 1
- ALL_STATEMENTS 1
- altering application online
- See: edition-based redefinition (EBR)
- analytic function 1
- ancestor edition 1
- ANSI data type 1
- ANYDATA data type 1
- ANYDATASET data type 1
- AP (application program) 1
- application architecture 1
- application domain index 1
- application program (AP) 1
- application SQL 1
- APPLYING_CROSSEDITION_TRIGGER function 1
- AQ (Oracle Advanced Queuing) 1
- archive
- See Flashback Data Archive 1
- ARGn data type 1
- arithmetic operation
- with datetime data type 1
- with native floating-point data type 1
- assignment, reported by PL/Scope 1
- auditing
- available options 1
- unified auditing 1
- auditing policy, editioning view and 1
- AUTHID clause
- in package specification 1
- stored subprogram and 1
- AUTHID property
- of invoked subprogram 1
- of PL/SQL unit 1, 2
- Automatic Database Diagnostic Monitor (ADDM) 1
- Automatic Undo Management system 1
- Automatic Workload Repository (AWR) 1
- autonomous transaction 1
- nonblocking DDL statement in 1
- trigger as 1
- auto-tuning OCI client statement cache 1
B
- backward compatibility
- LONG and LONG RAW data types for 1
- RESTRICT_REFERENCES pragma for 1
- BATCH commit redo option 1
- benchmark 1
- BINARY_DOUBLE data type 1
- BINARY_FLOAT data type 1
- BINARY_INTEGER data type
- See: PLS_INTEGER data type
- binary floating-point number 1
- binary format 1
- binary large object (BLOB) data type 1
- bind variables 1
- block, PL/SQL 1
- blocking DDL statement 1
- BOOLEAN data type 1
- branch 1
- built-in data type
- built-in function
- bulk binding 1
- business rule 1
E
- EBR (edition-based redefinition) 1
- edition 1
- ancestor 1
- creating 1
- crossedition triggers and 1
- current 1
- descendent 1
- displaying information about 1
- dropping 1
- enabling for user and types 1
- evaluation
- leaf 1
- making available
- to all users 1
- to some users 1
- ora$base 1, 2
- retiring 1
- root 1
- scope of 1
- session 1
- unusable
- visibility of trigger in 1
- EDITIONABLE property 1
- editionable schema object type 1
- edition-based redefinition (EBR) 1
- editioned object 1
- creating or replacing 1
- name resolution and 1
- editioning view 1
- auditing policy and 1
- changing base table of 1
- changing writability of 1
- covering table with 1
- creating 1
- displaying information about 1
- partition-extended name for 1
- preparing application for 1
- read-only 1
- read-write 1
- replacing 1
- scope of 1
- SQL optimizer hint and 1
- Electronic Product Code (EPC) 1
- embedded PL/SQL gateway 1
- enabling constraint
- effect of 1
- existing 1
- new 1
- enabling editions 1
- encoding scheme, adding 1
- environment, programming 1
- EPC (Electronic Product Code) 1
- evaluation edition 1
- dropping edition and 1
- for materialized view 1
- for virtual column 1
- retiring edition and 1
- exception
- IEEE 754 standard
- not raised 1
- raised during conversion 1
- in multilanguage program 1
- to constraint 1
- exception handling 1
- for storage allocation error 1
- EXCLUSIVE MODE option of LOCK TABLE statement 1
- EXECUTE privilege 1
- execution plan 1
- EXPLAIN PLAN statement 1
- explicit cursor 1
- EXPR data type 1
- expression
- index built on
- See function-based index 1
- regular
- extensibility 1
- external data type 1
- external large object (BFILE) data type 1
- external subprogram 1
- call specification for 1
- debugging 1
- loading 1
- managing for applications 1
- publishing 1
- external transaction manager 1
F
- family of data types
- FAN event, load balancing advisory 1
- Fast Application Notification (FAN) 1
- fine-grained access control 1
- fine-grained auditing (FGA) policy, editioning view and 1
- fine-grained invalidation 1
- firing order of triggers 1
- FIXED_DATE initialization parameter 1
- fixed-point data type 1
- Flashback Data Archive 1
- Flashback Transaction 1
- FLOAT data type 1
- floating-point data type 1
- See also: native floating-point data type
- floating-point number
- binary 1
- components of 1
- decimal 1
- denormal 1
- format of 1
- rounding 1
- subnormal 1
- FORCE option of ALTER USER statement 1
- FOREIGN KEY constraint 1
- distributed databases and 1
- dropping 1
- editioned view and 1
- enabling 1
- Flashback Transaction and 1
- indexing 1
- multiple 1
- naming 1
- NOT NULL constraint on 1
- NULL value and 1
- privileges needed to create 1
- referential integrity enforced by 1
- UNIQUE constraint on 1
- without other constraints 1
- foreign key dependency 1
- FOR loop
- bulk binding for 1
- that references collection 1
- forward compatibility 1
- forward crossedition trigger 1
- forward crossedition trigger SQL 1
- function 1
- aggregate 1
- analytic 1
- built-in
- DETERMINISTIC
- function-based index and 1
- RPC signature and 1
- invoking from SQL statement 1
- MGD_ID ADT 1
- OCI or OCCI 1
- PARALLEL_ENABLE, RPC signature and 1
- PL/SQL, invoked by SQL statement 1
- purity of 1
- result-cached 1
- returning large amount of data from 1
- SQL
- SQL analytic 1
- function-based index 1
- example for faster case-insensitive searches 1
- example for object columns 1
- example for precomputing arithmetic expressions 1
- optimizer and 1, 2
- function result cache 1
G
- generated column 1
- Geographic Information System (GIS) data 1
- GET_LTXID_OUTCOME procedure 1
- global transaction 1
- global variable, in C external subprogram 1
- greedy operator in regular expression 1
- group commit 1
H
- hierarchical profiler 1
- historical data, importing and exporting 1
- host language 1
- host program 1
- hot rollover 1
I
- IA-32 and IA-64 instruction set architecture 1
- IBM CICS 1
- IBM Transarc Encina 1
- Identity Code Package 1
- IEEE 754 standard 1
- See also: native floating-point data type
- exception
- not raised 1
- raised during conversion 1
- special values supported by 1
- IGNORE_ROW_ON_DUPKEY_INDEX hint 1
- IMMEDIATE commit redo option 1
- implementing database application 1
- implicit cursor 1
- independent transaction
- See: autonomous transaction
- index 1
- domain 1
- edition-based redefinition and 1
- function-based
- See function-based index 1
- on MGD_ID column 1
- infinity 1
- in-flight transaction 1
- INHERIT ANY PRIVILEGES system privilege 1
- inherited object 1
- INHERIT PRIVILEGES privilege 1
- initialization parameter 1
- DML_LOCKS 1
- FIXED_DATE 1
- NLS_DATE_FORMAT 1
- instrumentation 1
- integer data type class 1
- integrity constraint
- integrity of data
- interface 1
- See also: Oracle C++ Call Interface, Oracle Call Interface
- between PL/SQL and C 1
- between PL/SQL and Java 1
- program 1
- TX 1
- user 1
- invalidation
- cascading 1
- coarse-grained 1
- fine-grained 1
- of dependent object 1
- of package 1
- invoker’s rights 1
- affect on invoker’s privileges 1
- Java stored procedures 1
- invoking subprogram 1
- from subprogram 1
- from trigger 1
- interactively from Oracle Database tools 1
- through embedded PL/SQL gateway 1
- isolation level
- See: transaction isolation level
- iterative data processing
- about 1
- arrays 1
- manual parallelism 1
- row by row 1
J
- Java class method 1
- See also: external subprogram
- calling 1
- interface between PL/SQL and 1
- publishing 1
- Java Database Connectivity
- Java language
- compared to PL/SQL 1
- Oracle Database support for 1
- Java stored procedures 1
- Java Virtual Machine
- JDBC
- JVM
K
- key
- foreign
- See FOREIGN KEY constraint 1
- primary
- See PRIMARY KEY constraint 1
- unique
L
- Large Object (LOB) 1
- leaf edition 1
- LGWR (log writer process) 1
- lightweight queue 1
- live operation 1
- load balancing advisory FAN event 1
- LOB
- locking row explicitly 1
- locking table
- explicitly 1
- implicitly 1
- LOCK TABLE statement 1
- SELECT FOR UPDATE statement with 1
- logical design 1
- logical transaction identifier (LTXID) 1
- logical value 1
- log writer process (LGWR) 1
- LONG and LONG RAW data types 1
- LONG data type 1
- loose coupling 1
- LTXID (logical transaction identifier) 1
M
- maintaining database and application 1
- main transaction 1
- managing default rights 1
- materialized view 1
- that depends on editioned object 1
- maximum availability of table 1
- memory advisor 1
- metacharacter in regular expression 1
- metadata for SQL operator or function 1
- metrics 1
- MGD_ID ADT 1
- MGD_ID database ADT function 1
- mod_plsql module 1
- mode
- dependency 1
- lock 1
- serialized
- See serializable transaction 1
- MODIFY CONSTRAINT clause of ALTER TABLE statement 1
- modifying
- monitoring database performance 1
- multilanguage program 1
- multiline mode 1
- multilingual data 1
N
- name resolution 1
- NaN (not a number) 1
- national character large object (NCLOB) data type 1
- native execution 1
- native floating-point data type 1
- arithmetic operation with 1
- binary format for 1
- conversion functions for 1
- in client interfaces 1
- special values for 1
- NCHAR data type 1
- NCLOB data type 1
- negative infinity 1
- negative zero 1
- nested subprogram 1
- NLS_DATE_FORMAT initialization parameter 1
- NO_RESULT_CACHE hint 1
- nonblocking DDL statement 1
- in autonomous transaction 1
- NONEDITIONABLE property 1
- noneditionable schema object type 1
- noneditioned object 1
- creating or replacing 1
- name resolution and 1
- that can depend on editioned object 1
- dropping edition and 1
- FORCE and 1
- nongreedy operator in regular expression 1
- nonpersistent queue 1
- normalized significand 1
- NOT NULL
- See NOT NULL constraint 1
- NOT NULL constraint
- compared to CHECK constraint 1
- naming 1
- on FOREIGN KEY constraint 1
- when to use 1
- NOWAIT commit redo option 1
- NOWAIT option of LOCK TABLE statement 1
- NULL value
- FOREIGN KEY constraint and 1
- function-based index and 1
- indexing and 1
- NUMBER data type 1
- number data type class 1
- numeric data types 1
- NVARCHAR2 data type 1
P
- package
- creating 1
- dropping 1
- invalidation of 1
- session state and 1
- size limit for 1
- synonym for 1
- package body 1
- package invalidation and 1
- package specification 1
- package subprogram 1
- PARALLEL_ENABLE function
- parallelized SQL statement 1
- parameter
- compilation
- See compilation parameter 1
- initialization 1
- partition-extended editioning view name 1
- partitioning 1
- performance 1
- performance, data type and 1
- performance goals 1
- performance testing 1
- persistent LOB instance 1
- persistent queue 1
- phantom read 1
- physical design 1
- PL/Scope 1, 2
- PL/Scope security model 1
- PL/Scope tool 1
- PL/SQL block 1
- PL/SQL data type 1
- PL/SQL function result cache 1
- PL/SQL gateway 1
- PL/SQL hierarchical profiler 1
- PL/SQL Hierarchical Profiler 1
- PL/SQL language 1
- PL/SQL object
- PL/SQL optimize level 1
- PL/SQL optimizer level 1
- PL/SQL unit 1
- compiling for debugging 1
- CREATE OR REPLACE and 1
- PL/SQL Web Toolkit 1
- PLS_INTEGER data type 1
- plshprof utility 1
- PLSQL_CODE_COVERAGE package 1
- pool, connection 1
- positive infinity 1
- positive zero 1
- POSIX standard for regular expressions
- operators defined in 1
- Oracle SQL and 1
- Oracle SQL multilingual extensions to 1
- Oracle SQL PERL-influenced extensions to 1
- potentially editioned object 1
- with noneditioned dependents 1
- precompiler 1
- compared to Oracle Call Interface 1
- Oracle XA and 1
- PRIMARY KEY constraint 1
- dropping 1
- Flashback Transaction and 1
- naming 1
- primary key dependency 1
- privileges 1
- for debugging subprogram 1
- for defining constraint 1
- for Oracle Flashback Technology 1
- for running subprogram 1
- granting secure application roles 1
- grouped into roles 1
- INHERIT ANY PRIVILEGES system privilege 1
- INHERIT PRIVILEGES privilege 1
- revoked, object dependency and 1
- Pro*C/C++ precompiler 1
- native floating-point data types in 1
- Pro*COBOL precompiler 1
- procedure 1
- product code 1
- profiler 1
- program interface 1
- programming environment 1
- public information, required 1
- publish-subscribe model 1
- purity of function 1
Q
- quality-of-service flag 1
- query
- registering for Continuous Query Notification 1
- returning results to client 1
- Query Result Change Notification (QRCN) 1
- query rewrite 1
- queue 1
R
- Radio Frequency Identification (RFID) technology 1
- RAW data type 1
- raw data type class 1
- READ COMMITTED transaction isolation level
- compared to SERIALIZABLE 1
- in Oracle Database 1
- transaction interactions with 1
- read consistency 1
- statement-level 1
- transaction-level 1
- locking tables explicitly for 1
- read-only transaction for 1
- read lock 1
- read-only editioning view 1
- read-only transaction 1
- READ UNCOMMITTED transaction isolation level
- in Oracle Database 1
- transaction interactions with 1
- read-write editioning view 1
- record 1
- redefinition, edition-based (EBR) 1
- redo information for transaction 1
- redo management 1
- REF CURSOR data type 1
- referenced object
- See: schema object dependency
- referential integrity
- serializable transactions and 1
- trigger for enforcing 1
- referential integrity constraint
- See: FOREIGN KEY constraint
- REGEXP_COUNT function 1
- REGEXP_INSTR function 1
- REGEXP_LIKE condition 1
- REGEXP_REPLACE function 1
- back reference operator in 1
- REGEXP_SUBSTR function 1
- registration
- dynamic 1
- for Continuous Query Notification 1
- in publish-subscribe model 1
- static 1
- regular expression 1
- in Oracle SQL 1
- in SQL statement 1
- metacharacter in 1
- POSIX standard and
- See POSIX standard for regular expressions 1
- Unicode and 1
- remote dependency management 1
- remote procedure call dependency management 1
- remote subprogram 1
- repeatable read 1
- locking tables explicitly for 1
- read-only transaction for 1
- REPEATABLE READ transaction isolation level
- in Oracle Database 1
- transaction interactions with 1
- required public information 1
- resource manager (RM) 1
- RESTRICT_REFERENCES pragma
- for backward compatibility 1
- static and dynamic SQL and 1
- RESULT_CACHE_MODE session parameter 1
- RESULT_CACHE hint 1
- result cache 1
- resumable storage allocation 1
- RETENTION GUARANTEE clause for undo tablespace 1
- RETENTION option of ALTER TABLE statement 1
- RETURN_RESULT procedure 1
- reverse crossedition trigger 1
- reverse crossedition trigger SQL 1
- RFID (Radio Frequency Identification) technology 1
- RM (resource manager) 1
- roles 1
- root edition 1
- rounding floating-point numbers 1
- row
- address of (rowid) 1
- locking explicitly 1
- ROW EXCLUSIVE MODE option of LOCK TABLE statement 1
- rowid 1
- ROWID data type
- ROWID pseudocolumn 1
- ROW SHARE MODE option of LOCK TABLE statement 1
- RPC dependency management 1
- RR datetime format element 1
- rule on queue 1
- rules engine 1
- runtime connection load balancing 1
- runtime error
T
- table
- controlling user access to 1
- locking
- choosing strategy for 1
- explicitly 1
- implicitly 1
- with maximum availability 1
- with semi-availability 1
- table annotation 1
- table result cache mode
- annotation 1
- effective
- determining 1
- displaying 1
- Tag Data Translation Markup Language Schema 1
- Temporal Validity Support 1
- temporary LOB instance 1
- thin client configuration 1
- thread-safe application 1
- three-tier architecture 1
- tight coupling 1
- time 1
- See also: datetime data types
- default value for 1
- displaying 1
- inserting 1
- time-stamp checking 1
- time-stamp dependency mode 1
- TIMESTAMP WITH LOCAL TIME ZONE
- TIMESTAMP WITH TIME ZONE
- TM (transaction manager) 1
- TPM (transaction processing monitor) 1
- tracing tools 1
- transaction
- autonomous 1
- choosing isolation level for 1
- dependent 1
- determining outcome after outage 1
- distributed 1
- ensuring idempotence of 1
- global 1
- grouping operations into 1
- improving performance of 1
- in-flight 1
- main 1
- read-only 1
- redo entry for 1
- serializable
- See serializable transaction 1
- that invokes remote subprogram 1
- Transaction Guard 1, 2
- transaction history table 1
- transaction interaction
- kinds of 1
- serializable transaction and 1
- transaction isolation level and 1
- transaction isolation level
- choosing 1
- setting 1
- transaction interaction and 1
- transaction-level read consistency 1
- locking tables explicitly for 1
- read-only transaction for 1
- transaction manager (TM) 1
- transaction processing monitor (TPM) 1
- transaction set consistency 1
- transform 1
- trigger 1
- AFTER SUSPEND 1
- as autonomous transaction 1
- automating database login with 1
- compared to constraint 1
- crossedition
- See crossedition trigger 1
- enforcing referential integrity with 1
- in edition
- firing order of 1
- visibility of 1
- what kind can fire 1
- invoking subprogram from 1
- size limit for 1
- TRUST assertion (deprecated) 1
- TRUST keyword in RESTRICT_REFERENCES pragma 1
- two-phase commit protocol 1
- two-tier architecture 1
- TX interface 1
U
- undetected deadlock 1
- UNDO_RETENTION parameter 1
- undo data 1
- Unicode
- data types for 1
- regular expressions and 1
- unified auditing 1
- UNIQUE constraint
- crossedition trigger and 1
- dropping 1
- naming 1
- on FOREIGN KEY constraint 1
- when to use 1
- unrepeatable read 1
- unusable edition
- dropping edition and 1
- for materialized view 1
- retiring edition and 1
- upgrading applications online
- See: edition-based redefinition (EBR)
- UROWID data type 1
- user access
- user-defined subtype 1
- user interface 1
- user lock 1
- UTLLOCKT.SQL script 1
V
- VARCHAR2 data type 1
- VARCHAR data type 1
- VARCHAR data type class 1
- variable
- cursor
- in C external subprogram
- view
- constraint on 1
- editioned, FOREIGN KEY constraint and 1
- editioning
- materialized 1
- that depends on editioned object 1
- virtual column 1
- VPD policy, editioning view and 1
W
- WAIT commit redo option 1
- WAIT option of LOCK TABLE statement 1
- web application 1
- implementing 1
- state and 1
- web services 1
- web toolkit
- white list
- See: ACCESSIBLE BY clause
- wrap utility, debugging and 1
- writability of editioning view 1
- write-after-write dependency 1
X
- X/Open Distributed Transaction Processing (DTP) architecture 1
- xa_open string 1
- XMLType data type 1
Y
- YY datetime format element 1
Back to main content