|
Welcome
Seminars
Consultancy
Calendar
Presentations
Diagnostics
Internals
References
Acknowledgements
|
Oracle 10.1 Keywords
In Oracle 9.2 there were 806 keywords; in Oracle 10.1 there are 1062 keywords
The following table shows the 260 keywords that were added in Oracle 10.1
|
| Keyword |
| A |
| ADVISOR |
| AND_EQUAL |
| ANTIJOIN |
| APPEND |
| AUTHENTICATION |
| BIGFILE |
| BINARY_DOUBLE |
| BINARY_DOUBLE_INFINITY |
| BINARY_DOUBLE_NAN |
| BINARY_FLOAT |
| BINARY_FLOAT_INFINITY |
| BINARY_FLOAT_NAN |
| BLOCKS |
| BUFFER |
| BUFFER_CACHE |
| BYPASS_RECURSIVE_CHECK |
| BYPASS_UJVC |
| CACHE_CB |
| CACHE_TEMP_TABLE |
| CARDINALITY |
| CIV_GB |
| CLUSTERING_FACTOR |
| COARSE |
| COLLECTIONS_GET_REFS |
| COLUMN_STATS |
| COMPACT |
| CONNECT_BY_ISCYCLE |
| CONNECT_BY_ISLEAF |
| CONNECT_BY_ROOT |
| CONTENT |
| CPU_COSTING |
| CUBE_GB |
| CURSOR_SHARING_EXACT |
| DBA_RECYCLEBIN |
| DECREMENT |
| DEREF_NO_REWRITE |
| DML_UPDATE |
| DOCUMENT |
| DOMAIN_INDEX_NO_SORT |
| DOMAIN_INDEX_SORT |
| DOWNGRADE |
| DRIVING_SITE |
| DYNAMIC_SAMPLING |
| DYNAMIC_SAMPLING_EST_CDN |
| EMPTY |
| ENFORCED |
| ERROR |
| EXPAND_GSET_TO_UNION |
| EXPORT |
| EXPR_CORR_CHECK |
| FACT |
| FAILED |
| FBTSCAN |
| FIC_CIV |
| FIC_PIV |
| FINE |
| FORCE_XML_QUERY_REWRITE |
| GATHER_PLAN_STATISTICS |
| GBY_CONC_ROLLUP |
| GROUP_BY |
| GUARANTEE |
| HASH_AJ |
| HASH_SJ |
| HIGH |
| HINTSET_BEGIN |
| HINTSET_END |
| HWM_BROKERED |
| IDENTITY |
| IGNORE |
| IGNORE_ON_CLAUSE |
| IGNORE_OPTIM_EMBEDDED_HINTS |
| IGNORE_WHERE_CLAUSE |
| IMPORT |
| INCLUDE_VERSION |
| INDEX_ASC |
| INDEX_COMBINE |
| INDEX_DESC |
| INDEX_FFS |
| INDEX_FILTER |
| INDEX_JOIN |
| INDEX_ROWS |
| INDEX_RRS |
| INDEX_SCAN |
| INDEX_SKIP_SCAN |
| INDEX_SS |
| INDEX_SS_ASC |
| INDEX_SS_DESC |
| INDEX_STATS |
| INFINITE |
| INFORMATIONAL |
| INLINE |
| INTERPRETED |
| ITERATE |
| ITERATION_NUMBER |
| JOB |
| KEY_LENGTH |
| LENGTH |
| LIKE_EXPAND |
| LOCAL_INDEXES |
| MAIN |
| MATERIALIZE |
| MEASURES |
| MERGE_AJ |
| MERGE_CONST_ON |
| MERGE_SJ |
| MODEL |
| MODEL_DONTVERIFY_UNIQUENESS |
| MODEL_MIN_ANALYSIS |
| MODEL_NO_ANALYSIS |
| MODEL_PBY |
| MODEL_PUSH_REF |
| MV_MERGE |
| NAN |
| NATIVE |
| NAV |
| NESTED_TABLE_FAST_INSERT |
| NESTED_TABLE_GET_REFS |
| NESTED_TABLE_SET_REFS |
| NESTED_TABLE_SET_SETID |
| NL_AJ |
| NL_SJ |
| NOAPPEND |
| NOCPU_COSTING |
| NOGUARANTEE |
| NOPARALLEL_INDEX |
| NOREWRITE |
| NO_ACCESS |
| NO_BASETABLE_MULTIMV_REWRITE |
| NO_BUFFER |
| NO_CPU_COSTING |
| NO_EXPAND |
| NO_EXPAND_GSET_TO_UNION |
| NO_FACT |
| NO_FILTERING |
| NO_INDEX |
| NO_INDEX_FFS |
| NO_INDEX_SS |
| NO_MERGE |
| NO_MODEL_PUSH_REF |
| NO_MONITORING |
| NO_MULTIMV_REWRITE |
| NO_ORDER_ROLLUPS |
| NO_PARALLEL |
| NO_PARALLEL_INDEX |
| NO_PARTIAL_COMMIT |
| NO_PRUNE_GSETS |
| NO_PUSH_PRED |
| NO_PUSH_SUBQ |
| NO_QKN_BUFF |
| NO_QUERY_TRANSFORMATION |
| NO_REF_CASCADE |
| NO_REWRITE |
| NO_SEMIJOIN |
| NO_SET_TO_JOIN |
| NO_STAR_TRANSFORMATION |
| NO_STATS_GSETS |
| NO_SWAP_JOIN_INPUTS |
| NO_TRIGGER |
| NO_UNNEST |
| NO_USE_HASH |
| NO_USE_MERGE |
| NO_USE_NL |
| NO_XML_QUERY_REWRITE |
| OPAQUE_TRANSFORM |
| OPAQUE_XCANONICAL |
| OPTIMIZER_FEATURES_ENABLE |
| OPT_ESTIMATE |
| ORA_ROWSCN |
| ORDERED |
| ORDERED_PREDICATES |
| OR_EXPAND |
| OUT_OF_LINE |
| OVERFLOW_NOMOVE |
| PARALLEL_INDEX |
| PIV_GB |
| PIV_SSF |
| PLSQL_CODE_TYPE |
| PLSQL_OPTIMIZE_LEVEL |
| PLSQL_WARNINGS |
| POWER |
| PQ_DISTRIBUTE |
| PQ_MAP |
| PQ_NOMAP |
| PRESENT |
| PROGRAM |
| PROJECT |
| PUSH_PRED |
| PUSH_SUBQ |
| QB_NAME |
| QUERY_BLOCK |
| QUEUE_CURR |
| QUEUE_ROWP |
| RECYCLEBIN |
| REDUNDANCY |
| REFERENCE |
| REFERENCED |
| REF_CASCADE_CURSOR |
| REGEXP_LIKE |
| REMOTE_MAPPED |
| REQUIRED |
| RESTORE_AS_INTERVALS |
| RESTRICT_ALL_REF_CONS |
| REWRITE_OR_ERROR |
| ROW_LENGTH |
| RULES |
| SAVE_AS_INTERVALS |
| SCALE |
| SCALE_ROWS |
| SCHEDULER |
| SCN_ASCENDING |
| SEED |
| SEMIJOIN |
| SEMIJOIN_DRIVER |
| SEQUENTIAL |
| SET_TO_JOIN |
| SEVERE |
| SKIP_EXT_OPTIMIZER |
| SKIP_UNQ_UNUSABLE_IDX |
| SMALLFILE |
| SPREADSHEET |
| SQL |
| SQLLDR |
| STAR |
| STAR_TRANSFORMATION |
| STREAMS |
| STRIP |
| SUBMULTISET |
| SWAP_JOIN_INPUTS |
| SYSAUX |
| SYS_DL_CURSOR |
| SYS_FBT_INSDEL |
| SYS_PARALLEL_TXN |
| SYS_RID_ORDER |
| TABLE_STATS |
| TIV_GB |
| TIV_SSF |
| TRACKING |
| TRUSTED |
| TUNING |
| UNNEST |
| UPDATED |
| UPSERT |
| USER_RECYCLEBIN |
| USE_ANTI |
| USE_CONCAT |
| USE_HASH |
| USE_MERGE |
| USE_NL |
| USE_NL_WITH_INDEX |
| USE_SEMI |
| USE_TTT_FOR_GSETS |
| USE_WEAK_NAME_RESL |
| VECTOR_READ |
| VECTOR_READ_TRACE |
| VERSIONS |
| WELLFORMED |
| WHITESPACE |
| XMLPARSE |
| X_DYN_PRUNE |
|
The following table shows the four keywords that were removed from Oracle 10.1
|
| Name |
| DISPATCHERS |
| MTS_DISPATCHERS |
| NOSTRIPE |
| STRIPE |
|
|
