|
Welcome
Seminars
Consultancy
Calendar
Presentations
Diagnostics
Internals
References
Acknowledgements
|
Oracle 11.1 Keywords
In Oracle 10.2 there were 1129 keywords; in Oracle 11.1 there are 1733 keywords
The following table shows the 607 keywords that were added in Oracle 11.1
|
| Keyword |
| != |
| ; |
| <= |
| => |
| >= |
| ABS |
| ACOS |
| ACTIVE_COMPONENT |
| ACTIVE_FUNCTION |
| ACTIVE_TAG |
| ADD_MONTHS |
| ADJ_DATE |
| ANYSCHEMA |
| APPENDCHILDXML |
| ASCII |
| ASCIISTR |
| ASIN |
| ASSEMBLY |
| ASYNC |
| ATAN |
| ATAN2 |
| AVG |
| BASICFILE |
| BFILENAME |
| BINARY |
| BIN_TO_NUM |
| BITAND |
| BRANCH |
| CEIL |
| CHARTOROWID |
| CHECK_ACL_REWRITE |
| CHR |
| CLUSTER_ID |
| CLUSTER_PROBABILITY |
| CLUSTER_SET |
| COLD |
| COMPOSE |
| COMPOSITE |
| COMPOUND |
| CONCAT |
| CONNECT_BY_COMBINE_SW |
| CONNECT_BY_COST_BASED |
| CONNECT_BY_FILTERING |
| CONST |
| CONSTANT |
| CORR |
| CORRUPT_XID |
| CORRUPT_XID_ALL |
| CORR_K |
| CORR_S |
| COS |
| COSH |
| COST_XML_QUERY_REWRITE |
| COUNT |
| COVAR_POP |
| COVAR_SAMP |
| CO_AUTH_IND |
| CRASH |
| CROSSEDITION |
| CSCONVERT |
| CUME_DIST |
| CUME_DISTM |
| CURRENTV |
| CV |
| D |
| DATABASE_DEFAULT |
| DATAOBJ_TO_PARTITION |
| DB_VERSION |
| DEBUGGER |
| DECODE |
| DECOMPOSE |
| DECR |
| DEDUPLICATE |
| DEFAULTS |
| DELETEXML |
| DENSE_RANKM |
| DEPENDENT |
| DIRECT_LOAD |
| DISABLE_PRESET |
| DISALLOW |
| DOMAIN_INDEX_FILTER |
| EDITION |
| EDITIONING |
| EDITIONS |
| EMPTY_BLOB |
| EMPTY_CLOB |
| ENABLE_PRESET |
| ENCODING |
| ENTITYESCAPING |
| ERROR_ARGUMENT |
| EVERY |
| EXCLUDE |
| EXISTSNODE |
| EXP |
| EXTRA |
| EXTRACTVALUE |
| FACILITY |
| FEATURE_ID |
| FEATURE_SET |
| FEATURE_VALUE |
| FILESYSTEM_LIKE_LOGGING |
| FIRSTM |
| FIRST_VALUE |
| FLOOR |
| FOLDER |
| FOLLOWS |
| FOREVER |
| FORWARD |
| FROM_TZ |
| GBY_PUSHDOWN |
| GREATEST |
| GROUPING_ID |
| GROUP_ID |
| H |
| HELP |
| HEXTORAW |
| HEXTOREF |
| HIDDEN |
| HIDE |
| HOT |
| IMPACT |
| INCLUDE |
| INCR |
| INDENT |
| INDEX_RS |
| INDEX_RS_ASC |
| INDEX_RS_DESC |
| INHERITED |
| INITCAP |
| INSERTCHILDXML |
| INSERTCHILDXMLAFTER |
| INSERTCHILDXMLBEFORE |
| INSERTXMLBEFORE |
| INSTR |
| INSTR2 |
| INSTR4 |
| INSTRB |
| INSTRC |
| INVISIBLE |
| IN_XQUERY |
| KEEP_DUPLICATES |
| LAG |
| LAST_DAY |
| LAST_VALUE |
| LEAD |
| LEAST |
| LENGTH2 |
| LENGTH4 |
| LENGTHB |
| LENGTHC |
| LIFE |
| LIFETIME |
| LN |
| LNNVL |
| LOBNVL |
| LOW |
| LOWER |
| LPAD |
| LTRIM |
| MAKE_REF |
| MEASURE |
| MEDIAN |
| MEDIUM |
| MERGE$ACTIONS |
| MIGRATION |
| MINING |
| MIRRORCOLD |
| MIRRORHOT |
| MOD |
| MONITOR |
| MONTHS_BETWEEN |
| MOUNTPATH |
| NAMESPACE |
| NANVL |
| NATIVE_FULL_OUTER_JOIN |
| NCHR |
| NEW_TIME |
| NEXT_DAY |
| NLJ_BATCHING |
| NLJ_PREFETCH |
| NLSSORT |
| NLS_CHARSET_DECL_LEN |
| NLS_CHARSET_ID |
| NLS_CHARSET_NAME |
| NLS_INITCAP |
| NLS_LOWER |
| NLS_UPPER |
| NOENTITYESCAPING |
| NOLOCAL |
| NONSCHEMA |
| NOSCHEMACHECK |
| NO_CHECK_ACL_REWRITE |
| NO_CONNECT_BY_COMBINE_SW |
| NO_CONNECT_BY_COST_BASED |
| NO_CONNECT_BY_FILTERING |
| NO_COST_XML_QUERY_REWRITE |
| NO_DOMAIN_INDEX_FILTER |
| NO_GBY_PUSHDOWN |
| NO_LOAD |
| NO_MONITOR |
| NO_NATIVE_FULL_OUTER_JOIN |
| NO_NLJ_BATCHING |
| NO_NLJ_PREFETCH |
| NO_OUTER_JOIN_TO_INNER |
| NO_PLACE_GROUP_BY |
| NO_PQ_MAP |
| NO_RESULT_CACHE |
| NO_SUBQUERY_PRUNING |
| NO_XMLINDEX_REWRITE |
| NO_XMLINDEX_REWRITE_IN_SELECT |
| NO_XML_DML_REWRITE |
| NTILE |
| NULLIF |
| NUMTODSINTERVAL |
| NUMTOYMINTERVAL |
| NUM_INDEX_KEYS |
| NVL |
| NVL2 |
| OBJECTTOXML |
| OCCURENCES |
| OLAP |
| OPERATIONS |
| ORADEBUG |
| ORA_BRANCH |
| ORA_HASH |
| ORA_ROWVERSION |
| ORA_TABVERSION |
| OTHER |
| OUTER_JOIN_TO_INNER |
| OWNER |
| OWNERSHIP |
| PARAM |
| PBL_HS_BEGIN |
| PBL_HS_END |
| PENDING |
| PERCENTILE_CONT |
| PERCENTILE_DISC |
| PERCENT_RANK |
| PERCENT_RANKM |
| PERMISSION |
| PIVOT |
| PLACE_GROUP_BY |
| PLSCOPE_SETTINGS |
| POWERMULTISET |
| POWERMULTISET_BY_CARDINALITY |
| PRECEDES |
| PREDICTION |
| PREDICTION_BOUNDS |
| PREDICTION_COST |
| PREDICTION_DETAILS |
| PREDICTION_PROBABILITY |
| PREDICTION_SET |
| PRESENTNNV |
| PRESENTV |
| PREVIOUS |
| PROCEDURAL |
| PROCESS |
| PROPAGATE |
| RANK |
| RANKM |
| RATIO_TO_REPORT |
| RAWTOHEX |
| RAWTONHEX |
| REDO |
| REFTOHEX |
| REGEXP_COUNT |
| REGEXP_INSTR |
| REGEXP_REPLACE |
| REGEXP_SUBSTR |
| REGR_AVGX |
| REGR_AVGY |
| REGR_COUNT |
| REGR_INTERCEPT |
| REGR_R2 |
| REGR_SLOPE |
| REGR_SXX |
| REGR_SXY |
| REGR_SYY |
| REMAINDER |
| REMOVE |
| REPLICATION |
| RESULT_CACHE |
| ROUND |
| ROWIDTOCHAR |
| ROWIDTONCHAR |
| ROW_NUMBER |
| RPAD |
| RTRIM |
| SCHEMACHECK |
| SECUREFILE |
| SHOW |
| SIGN |
| SIGNAL_COMPONENT |
| SIGNAL_FUNCTION |
| SIN |
| SINH |
| SOUNDEX |
| SQRT |
| STALE |
| STATS_BINOMIAL_TEST |
| STATS_CROSSTAB |
| STATS_F_TEST |
| STATS_KS_TEST |
| STATS_MODE |
| STATS_MW_TEST |
| STATS_ONE_WAY_ANOVA |
| STATS_T_TEST_INDEP |
| STATS_T_TEST_INDEPU |
| STATS_T_TEST_ONE |
| STATS_T_TEST_PAIRED |
| STATS_WSR_TEST |
| STDDEV |
| STDDEV_POP |
| STDDEV_SAMP |
| STRIPE_COLUMNS |
| STRIPE_WIDTH |
| SUBQUERY_PRUNING |
| SUBSTR |
| SUBSTR2 |
| SUBSTR4 |
| SUBSTRB |
| SUBSTRC |
| SUM |
| SYNC |
| SYSASM |
| SYSTEM_DEFINED |
| SYS_AUDIT |
| SYS_CHECKACL |
| SYS_CONNECT_BY_PATH |
| SYS_CONTEXT |
| SYS_DBURIGEN |
| SYS_DM_RXFORM_CHR |
| SYS_DM_RXFORM_NUM |
| SYS_DOM_COMPARE |
| SYS_ET_BFILE_TO_RAW |
| SYS_ET_BLOB_TO_IMAGE |
| SYS_ET_IMAGE_TO_BLOB |
| SYS_ET_RAW_TO_BFILE |
| SYS_EXTRACT_UTC |
| SYS_FILTER_ACLS |
| SYS_GET_ACLIDS |
| SYS_GET_PRIVILEGES |
| SYS_GUID |
| SYS_MAKEXML |
| SYS_MAKE_XMLNODEID |
| SYS_MKXMLATTR |
| SYS_OPTXICMP |
| SYS_OPTXQCASTASNQ |
| SYS_OP_ADT2BIN |
| SYS_OP_ADTCONS |
| SYS_OP_ALSCRVAL |
| SYS_OP_ATG |
| SYS_OP_BIN2ADT |
| SYS_OP_BL2R |
| SYS_OP_BLOOM_FILTER |
| SYS_OP_C2C |
| SYS_OP_CEG |
| SYS_OP_CL2C |
| SYS_OP_COMBINED_HASH |
| SYS_OP_COMP |
| SYS_OP_CONVERT |
| SYS_OP_COUNTCHG |
| SYS_OP_CSR |
| SYS_OP_CSX_PATCH |
| SYS_OP_DECOMP |
| SYS_OP_DESCEND |
| SYS_OP_DISTINCT |
| SYS_OP_DRA |
| SYS_OP_DUMP |
| SYS_OP_GROUPING |
| SYS_OP_GUID |
| SYS_OP_IIX |
| SYS_OP_ITR |
| SYS_OP_LBID |
| SYS_OP_LOBLOC2BLOB |
| SYS_OP_LOBLOC2CLOB |
| SYS_OP_LOBLOC2ID |
| SYS_OP_LOBLOC2NCLOB |
| SYS_OP_LOBLOC2TYP |
| SYS_OP_LSVI |
| SYS_OP_LVL |
| SYS_OP_MAKEOID |
| SYS_OP_MAP_NONNULL |
| SYS_OP_MSR |
| SYS_OP_NICOMBINE |
| SYS_OP_NIEXTRACT |
| SYS_OP_NII |
| SYS_OP_NIX |
| SYS_OP_NUMTORAW |
| SYS_OP_OIDVALUE |
| SYS_OP_OPNSIZE |
| SYS_OP_PAR |
| SYS_OP_PARGID |
| SYS_OP_PARGID_1 |
| SYS_OP_PAR_1 |
| SYS_OP_PIVOT |
| SYS_OP_R2O |
| SYS_OP_RAWTONUM |
| SYS_OP_RDTM |
| SYS_OP_REF |
| SYS_OP_RMTD |
| SYS_OP_ROWIDTOOBJ |
| SYS_OP_RPB |
| SYS_OP_TOSETID |
| SYS_OP_TPR |
| SYS_OP_TRTB |
| SYS_OP_UNDESCEND |
| SYS_OP_VECAND |
| SYS_OP_VECBIT |
| SYS_OP_VECOR |
| SYS_OP_VECXOR |
| SYS_OP_VERSION |
| SYS_OP_VREF |
| SYS_OP_VVD |
| SYS_OP_XPTHATG |
| SYS_OP_XPTHIDX |
| SYS_OP_XPTHOP |
| SYS_OP_XTXT2SQLT |
| SYS_ORDERKEY_DEPTH |
| SYS_ORDERKEY_MAXCHILD |
| SYS_ORDERKEY_PARENT |
| SYS_PATHID_IS_ATTR |
| SYS_PATHID_IS_NMSPC |
| SYS_PATHID_LASTNAME |
| SYS_PATHID_LASTNMSPC |
| SYS_PATH_REVERSE |
| SYS_PXQEXTRACT |
| SYS_ROW_DELTA |
| SYS_SYNRCIREDO |
| SYS_TYPEID |
| SYS_UMAKEXML |
| SYS_XMLCONTAINS |
| SYS_XMLCONV |
| SYS_XMLEXNSURI |
| SYS_XMLGEN |
| SYS_XMLI_LOC_ISNODE |
| SYS_XMLI_LOC_ISTEXT |
| SYS_XMLLOCATOR_GETSVAL |
| SYS_XMLNODEID |
| SYS_XMLNODEID_GETCID |
| SYS_XMLNODEID_GETLOCATOR |
| SYS_XMLNODEID_GETOKEY |
| SYS_XMLNODEID_GETPATHID |
| SYS_XMLNODEID_GETRID |
| SYS_XMLNODEID_GETSVAL |
| SYS_XMLNODEID_GETTID |
| SYS_XMLTRANSLATE |
| SYS_XMLTYPE2SQL |
| SYS_XMLT_2_SC |
| SYS_XQBASEURI |
| SYS_XQCASTABLEERRH |
| SYS_XQCODEP2STR |
| SYS_XQCODEPEQ |
| SYS_XQCON2SEQ |
| SYS_XQCONCAT |
| SYS_XQDFLTCOLATION |
| SYS_XQDOCURI |
| SYS_XQED4URI |
| SYS_XQENDSWITH |
| SYS_XQERR |
| SYS_XQERRH |
| SYS_XQESHTMLURI |
| SYS_XQEXSTWRP |
| SYS_XQEXTRACT |
| SYS_XQEXTRREF |
| SYS_XQEXVAL |
| SYS_XQFNBOOL |
| SYS_XQFNCMP |
| SYS_XQFNDATIM |
| SYS_XQFNLNAME |
| SYS_XQFNNM |
| SYS_XQFNNSURI |
| SYS_XQFNPREDTRUTH |
| SYS_XQFNQNM |
| SYS_XQFNROOT |
| SYS_XQFUNCR |
| SYS_XQGETCONTENT |
| SYS_XQINDXOF |
| SYS_XQINSPFX |
| SYS_XQIRI2URI |
| SYS_XQLLNMFRMQNM |
| SYS_XQMKNODEREF |
| SYS_XQNILLED |
| SYS_XQNODENAME |
| SYS_XQNORMSPACE |
| SYS_XQNORMUCODE |
| SYS_XQNSP4PFX |
| SYS_XQNSPFRMQNM |
| SYS_XQPFXFRMQNM |
| SYS_XQPOLYABS |
| SYS_XQPOLYADD |
| SYS_XQPOLYCEL |
| SYS_XQPOLYCST |
| SYS_XQPOLYCSTBL |
| SYS_XQPOLYDIV |
| SYS_XQPOLYFLR |
| SYS_XQPOLYMOD |
| SYS_XQPOLYMUL |
| SYS_XQPOLYRND |
| SYS_XQPOLYSQRT |
| SYS_XQPOLYSUB |
| SYS_XQPOLYUMUS |
| SYS_XQPOLYUPLS |
| SYS_XQPOLYVEQ |
| SYS_XQPOLYVGE |
| SYS_XQPOLYVGT |
| SYS_XQPOLYVLE |
| SYS_XQPOLYVLT |
| SYS_XQPOLYVNE |
| SYS_XQREF2VAL |
| SYS_XQRESVURI |
| SYS_XQRNDHALF2EVN |
| SYS_XQRSLVQNM |
| SYS_XQRYENVPGET |
| SYS_XQRYVARGET |
| SYS_XQRYWRP |
| SYS_XQSEQ2CON |
| SYS_XQSEQ2CON4XC |
| SYS_XQSEQDEEPEQ |
| SYS_XQSEQINSB |
| SYS_XQSEQRM |
| SYS_XQSEQRVS |
| SYS_XQSEQSUB |
| SYS_XQSEQTYPMATCH |
| SYS_XQSTARTSWITH |
| SYS_XQSTATBURI |
| SYS_XQSTR2CODEP |
| SYS_XQSTRJOIN |
| SYS_XQSUBSTRAFT |
| SYS_XQSUBSTRBEF |
| SYS_XQTREATAS |
| SYS_XQ_ASQLCNV |
| SYS_XQ_ATOMCNVCHK |
| SYS_XQ_NRNG |
| SYS_XQ_PKSQL2XML |
| SYS_XQ_UPKXML2SQL |
| TAN |
| TANH |
| TBL$OR$IDX$PART$NUM |
| TIMES |
| TO_BINARY_DOUBLE |
| TO_BINARY_FLOAT |
| TO_BLOB |
| TO_CLOB |
| TO_DATE |
| TO_DSINTERVAL |
| TO_LOB |
| TO_MULTI_BYTE |
| TO_NCHAR |
| TO_NCLOB |
| TO_NUMBER |
| TO_SINGLE_BYTE |
| TO_TIME |
| TO_TIMESTAMP |
| TO_TIMESTAMP_TZ |
| TO_TIME_TZ |
| TO_YMINTERVAL |
| TRANSITION |
| TRANSLATE |
| TRIM |
| TRUNC |
| UNISTR |
| UNPIVOT |
| UNRESTRICTED |
| UPDATEXML |
| UPPER |
| USERENV |
| USERGROUP |
| USE_INVISIBLE_INDEXES |
| USE_MERGE_CARTESIAN |
| VARIANCE |
| VAR_POP |
| VAR_SAMP |
| VERIFY |
| VERSIONING |
| VERSIONS_ENDSCN |
| VERSIONS_ENDTIME |
| VERSIONS_OPERATION |
| VERSIONS_STARTSCN |
| VERSIONS_STARTTIME |
| VERSIONS_XID |
| VIRTUAL |
| VISIBLE |
| VOLUME |
| VSIZE |
| WIDTH_BUCKET |
| XML |
| XMLCAST |
| XMLCDATA |
| XMLCOMMENT |
| XMLCONCAT |
| XMLDIFF |
| XMLEXISTS |
| XMLEXISTS2 |
| XMLINDEX_REWRITE |
| XMLINDEX_REWRITE_IN_SELECT |
| XMLISNODE |
| XMLISVALID |
| XMLPATCH |
| XMLTOOBJECT |
| XMLTRANSFORM |
| XMLTRANSFORMBLOB |
| XML_DML_RWT_STMT |
| XPATHTABLE |
| XS_SYS_CONTEXT |
| { |
| } |
|
The following table shows the three keywords that were removed in Oracle 11.1
|
| Name |
| CIV_GB |
| FIC_CIV |
| FIC_PIV |
|
|
