Skip to content

Instantly share code, notes, and snippets.

@neilkod
Created January 6, 2011 15:53
Show Gist options
  • Save neilkod/768054 to your computer and use it in GitHub Desktop.
Save neilkod/768054 to your computer and use it in GitHub Desktop.
words found in v$reserved_words in 11gr2 which are not in 10gr2
KEYWORD
------------------------------
!=
;
<=
=>
>=
ABS
ACOS
ACTIVE_COMPONENT
ACTIVE_FUNCTION
ACTIVE_TAG
ADD_COLUMN
ADD_GROUP
ADD_MONTHS
ADJ_DATE
ANYSCHEMA
APPENDCHILDXML
APPEND_VALUES
ASCII
ASCIISTR
ASIN
ASSEMBLY
ASYNC
ASYNCHRONOUS
ATAN
ATAN2
AVG
BASIC
BASICFILE
BFILENAME
BINARY
BIND_AWARE
BIN_TO_NUM
BITAND
BRANCH
BREADTH
CEIL
CELL_FLASH_CACHE
CHANGE_DUPKEY_ERROR_INDEX
CHARTOROWID
CHECK_ACL_REWRITE
CHR
CLUSTER_ID
CLUSTER_PROBABILITY
CLUSTER_SET
COALESCE_SQ
COLD
COLUMNAR
COLUMN_AUTH_INDICATOR
COMPLIANCE
COMPOSE
COMPOSITE
COMPOUND
CONCAT
CONFIRM
CONNECT_BY_CB_WHR_ONLY
CONNECT_BY_ELIM_DUPS
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
CREATION
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
DEPTH
DIRECT_LOAD
DISABLE_PRESET
DISALLOW
DOCFIDELITY
DOMAIN_INDEX_FILTER
DROP_COLUMN
DROP_GROUP
DST_UPGRADE_INSERT_CONV
EDITION
EDITIONING
EDITIONS
EMPTY_BLOB
EMPTY_CLOB
ENABLE_PRESET
ENCODING
ENTITYESCAPING
ERROR_ARGUMENT
EVERY
EXCLUDE
EXISTSNODE
EXP
EXPAND_TABLE
EXTRA
EXTRACTVALUE
FACILITY
FACTORIZE_JOIN
FEATURE_ID
FEATURE_SET
FEATURE_VALUE
FILESYSTEM_LIKE_LOGGING
FIRSTM
FIRST_VALUE
FLASH_CACHE
FLOOR
FOLDER
FOLLOWS
FOREVER
FORWARD
FROM_TZ
GBY_PUSHDOWN
GREATEST
GROUPING_ID
GROUP_ID
H
HELP
HEXTORAW
HEXTOREF
HIDDEN
HIDE
HOT
HYBRID
IGNORE_ROW_ON_DUPKEY_INDEX
IMPACT
INCLUDE
INCR
INDENT
INITCAP
INSERTCHILDXML
INSERTCHILDXMLAFTER
INSERTCHILDXMLBEFORE
INSERTXMLAFTER
INSERTXMLBEFORE
INSTR
INSTR2
INSTR4
INSTRB
INSTRC
INVISIBLE
IN_XQUERY
KEEP_DUPLICATES
LAG
LAST_DAY
LAST_VALUE
LEAD
LEAST
LENGTH2
LENGTH4
LENGTHB
LENGTHC
LIFE
LIFETIME
LISTAGG
LN
LNNVL
LOBNVL
LOBS
LOGFILES
LOW
LOWER
LPAD
LTRIM
MAKE_REF
MEASURE
MEDIAN
MEDIUM
MERGE$ACTIONS
MIGRATION
MINING
MIRRORCOLD
MIRRORHOT
MOD
MONITOR
MONTHS_BETWEEN
MOUNTPATH
NAMESPACE
NANVL
NCHR
NEW_TIME
NEXT_DAY
NLJ_BATCHING
NLJ_INDEX_FILTER
NLJ_INDEX_SCAN
NLJ_PREFETCH
NLSSORT
NLS_CHARSET_DECL_LEN
NLS_CHARSET_ID
NLS_CHARSET_NAME
NLS_INITCAP
NLS_LOWER
NLS_UPPER
NOENTITYESCAPING
NOLOCAL
NONSCHEMA
NOSCHEMACHECK
NO_BIND_AWARE
NO_CHECK_ACL_REWRITE
NO_COALESCE_SQ
NO_CONNECT_BY_CB_WHR_ONLY
NO_CONNECT_BY_ELIM_DUPS
NO_COST_XML_QUERY_REWRITE
NO_DOMAIN_INDEX_FILTER
NO_DST_UPGRADE_INSERT_CONV
NO_EXPAND_TABLE
NO_FACTORIZE_JOIN
NO_GBY_PUSHDOWN
NO_LOAD
NO_MONITOR
NO_NLJ_BATCHING
NO_NLJ_PREFETCH
NO_OUTER_JOIN_TO_INNER
NO_PLACE_DISTINCT
NO_PLACE_GROUP_BY
NO_PQ_MAP
NO_RESULT_CACHE
NO_STATEMENT_QUEUING
NO_SUBQUERY_PRUNING
NO_SUBSTRB_PAD
NO_TRANSFORM_DISTINCT_AGG
NO_USE_INVISIBLE_INDEXES
NO_XMLINDEX_REWRITE
NO_XMLINDEX_REWRITE_IN_SELECT
NTH_VALUE
NTILE
NULLIF
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
NVL2
OBJECTTOXML
OCCURENCES
OLAP
OLTP
OPERATIONS
ORADEBUG
ORA_BRANCH
ORA_CHECKACL
ORA_DST_AFFECTED
ORA_DST_CONVERT
ORA_DST_ERROR
ORA_GET_ACLIDS
ORA_GET_PRIVILEGES
ORA_HASH
ORA_ROWSCN_RAW
ORA_ROWVERSION
ORA_TABVERSION
OR_PREDICATES
OTHER
OUTER_JOIN_TO_INNER
OWNER
OWNERSHIP
PART$NUM$INST
PBL_HS_BEGIN
PBL_HS_END
PENDING
PERCENTILE_CONT
PERCENTILE_DISC
PERCENT_RANK
PERCENT_RANKM
PERMISSION
PIKEY
PIVOT
PLACE_DISTINCT
PLACE_GROUP_BY
PLSCOPE_SETTINGS
POWERMULTISET
POWERMULTISET_BY_CARDINALITY
PRECEDES
PREDICATE_REORDERS
PREDICTION
PREDICTION_BOUNDS
PREDICTION_COST
PREDICTION_DETAILS
PREDICTION_PROBABILITY
PREDICTION_SET
PRESENTNNV
PRESENTV
PREVIOUS
PROCEDURAL
PROCESS
PROPAGATE
QUORUM
RANDOM_LOCAL
RANK
RANKM
RATIO_TO_REPORT
RAWTOHEX
RAWTONHEX
RDBA
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
REGULAR
REMAINDER
REMOVE
REPEAT
REPLICATION
RESPECT
RESULT_CACHE
RETRY_ON_ROW_CHANGE
ROUND
ROWIDTOCHAR
ROWIDTONCHAR
ROW_NUMBER
RPAD
RTRIM
SCHEMACHECK
SEARCH
SECUREFILE
SECUREFILE_DBA
SHOW
SIGN
SIGNAL_COMPONENT
SIGNAL_FUNCTION
SIN
SINH
SOUNDEX
SQRT
STALE
STANDBY_MAX_DATA_DELAY
STATEMENTS
STATEMENT_QUEUING
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
SYNCHRONOUS
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_DST_PRIM2SEC
SYS_DST_SEC2PRIM
SYS_ET_BFILE_TO_RAW
SYS_ET_BLOB_TO_IMAGE
SYS_ET_IMAGE_TO_BLOB
SYS_ET_RAW_TO_BFILE
SYS_EXTPDTXT
SYS_EXTRACT_UTC
SYS_FILTER_ACLS
SYS_GETTOKENID
SYS_GET_ACLIDS
SYS_GET_PRIVILEGES
SYS_GUID
SYS_MAKEXML
SYS_MAKE_XMLNODEID
SYS_MKXMLATTR
SYS_OPTLOBPRBSC
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_BLOOM_FILTER_LIST
SYS_OP_C2C
SYS_OP_CEG
SYS_OP_CL2C
SYS_OP_COMBINED_HASH
SYS_OP_COMP
SYS_OP_CONVERT
SYS_OP_COUNTCHG
SYS_OP_CSCONV
SYS_OP_CSCONVTEST
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_SC_2_XMLT
SYS_SYNRCIREDO
SYS_TYPEID
SYS_UMAKEXML
SYS_XMLANALYZE
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_GETPTRID
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_XQDELETE
SYS_XQDFLTCOLATION
SYS_XQDOC
SYS_XQDOCURI
SYS_XQED4URI
SYS_XQENDSWITH
SYS_XQERR
SYS_XQERRH
SYS_XQESHTMLURI
SYS_XQEXLOBVAL
SYS_XQEXSTWRP
SYS_XQEXTRACT
SYS_XQEXTRREF
SYS_XQEXVAL
SYS_XQFB2STR
SYS_XQFNBOOL
SYS_XQFNCMP
SYS_XQFNDATIM
SYS_XQFNLNAME
SYS_XQFNNM
SYS_XQFNNSURI
SYS_XQFNPREDTRUTH
SYS_XQFNQNM
SYS_XQFNROOT
SYS_XQFORMATNUM
SYS_XQFTCONTAIN
SYS_XQFUNCR
SYS_XQGETCONTENT
SYS_XQINDXOF
SYS_XQINSERT
SYS_XQINSPFX
SYS_XQIRI2URI
SYS_XQLANG
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_XQRENAME
SYS_XQREPLACE
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_XQTOKENIZE
SYS_XQTREATAS
SYS_XQXFORM
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
TRANSFORM_DISTINCT_AGG
TRANSITION
TRANSLATE
TRIM
TRUNC
UNISTR
UNPIVOT
UNRESTRICTED
UPDATEXML
UPPER
USERENV
USERGROUP
USE_INVISIBLE_INDEXES
VARIANCE
VARRAYS
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
XMLINDEX_SEL_IDX_TBL
XMLISNODE
XMLISVALID
XMLPATCH
XMLTOOBJECT
XMLTRANSFORM
XMLTRANSFORMBLOB
XPATHTABLE
XS_SYS_CONTEXT
{
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment