Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Keywords

In Oracle 10.1 there were 1062 keywords; in Oracle 10.2 there are 1127 keywords

The following table shows the 75 keywords that were added in Oracle 10.2

Keyword
BATCH
BEGIN_OUTLINE_DATA
BITMAPS
BITMAP_TREE
DBMS_STATS
DB_ROLE_CHANGE
DECRYPT
DEQUEUE
DISABLE_RPKE
E
ELIMINATE_JOIN
ELIMINATE_OBY
ELIMINATE_OUTER_JOIN
ENCRYPT
END_OUTLINE_DATA
ENQUEUE
ENTERPRISE
ERRORS
EVALNAME
EVALUATION
G
INLINE_XMLTYPE_NT
K
M
MINUS_NULL
MODEL_COMPILE_SUBQUERY
MODEL_DYNAMIC_SUBQUERY
NOTIFICATION
NO_CARTESIAN
NO_ELIMINATE_JOIN
NO_ELIMINATE_OBY
NO_ELIMINATE_OUTER_JOIN
NO_PULL_PRED
NO_PX_JOIN_FILTER
NO_SQL_TUNE
NO_TEMP_TABLE
NO_USE_HASH_AGGREGATION
OLD_PUSH_PRED
OPT_PARAM
ORDINALITY
OUTLINE_LEAF
P
PASSING
PATH
PATHS
PLSQL_CCFLAGS
POINT
PRECOMPUTE_SUBQUERY
PRESERVE_OID
PULL_PRED
PX_JOIN_FILTER
RBO_OUTLINE
RESTORE
ROLLING
SALT
STANDALONE
STRING
SUBQUERIES
SYS_OP_EXTRACT
T
TEMP_TABLE
TIMEZONE_OFFSET
TO_CHAR
U
USERS
USE_HASH_AGGREGATION
WALLET
WRAPPED
XMLNAMESPACES
XMLPI
XMLQUERY
XMLROOT
XMLSERIALIZE
XMLTABLE
YES

The following table shows the 10 keywords that were removed in Oracle 10.2

Name
ALGORITHM
COLLECTIONS_GET_REFS
ENCRYPTED
EXTEND
IGNORE_ON_CLAUSE
INTEGRITY
KEYFILE
NO_TRIGGER
SYS_OP_COL_PRESENT
SYS_OP_MINE_VALUE