• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    数据库 关键字一览表

    数据库 关键字:

    为了避免在数据库表结构设计过程中使用系统保留关键字我们必须知道数据库存在哪些关键字,接下来会列出mysql、oracle、sqlserver三个数据库各自的保留关键字。

    Mysql

    http://dev.mysql.com/doc/refman/5.7/en/keywords.html

    ACCESSIBLE (R) ACCOUNT[a] ACTION
    ADD (R) AFTER AGAINST
    AGGREGATE ALGORITHM ALL (R)
    ALTER (R) ALWAYS[b] ANALYSE
    ANALYZE (R) AND (R) ANY
    AS (R) ASC (R) ASCII
    ASENSITIVE (R) AT AUTOEXTEND_SIZE
    AUTO_INCREMENT AVG AVG_ROW_LENGTH
    BACKUP BEFORE (R) BEGIN
    BETWEEN (R) BIGINT (R) BINARY (R)
    BINLOG BIT BLOB (R)
    BLOCK BOOL BOOLEAN
    BOTH (R) BTREE BY (R)
    BYTE CACHE CALL (R)
    CASCADE (R) CASCADED CASE (R)
    CATALOG_NAME CHAIN CHANGE (R)
    CHANGED CHANNEL[c] CHAR (R)
    CHARACTER (R) CHARSET CHECK (R)
    CHECKSUM CIPHER CLASS_ORIGIN
    CLIENT CLOSE COALESCE
    CODE COLLATE (R) COLLATION
    COLUMN (R) COLUMNS COLUMN_FORMAT
    COLUMN_NAME COMMENT COMMIT
    COMMITTED COMPACT COMPLETION
    COMPRESSED COMPRESSION[d] CONCURRENT
    CONDITION (R) CONNECTION CONSISTENT
    CONSTRAINT (R) CONSTRAINT_CATALOG CONSTRAINT_NAME
    CONSTRAINT_SCHEMA CONTAINS CONTEXT
    CONTINUE (R) CONVERT (R) CPU
    CREATE (R) CROSS (R) CUBE
    CURRENT CURRENT_DATE (R) CURRENT_TIME (R)
    CURRENT_TIMESTAMP (R) CURRENT_USER (R) CURSOR (R)
    CURSOR_NAME DATA DATABASE (R)
    DATABASES (R) DATAFILE DATE
    DATETIME DAY DAY_HOUR (R)
    DAY_MICROSECOND (R) DAY_MINUTE (R) DAY_SECOND (R)
    DEALLOCATE DEC (R) DECIMAL (R)
    DECLARE (R) DEFAULT (R) DEFAULT_AUTH
    DEFINER DELAYED (R) DELAY_KEY_WRITE
    DELETE (R) DESC (R) DESCRIBE (R)
    DES_KEY_FILE DETERMINISTIC (R) DIAGNOSTICS
    DIRECTORY DISABLE DISCARD
    DISK DISTINCT (R) DISTINCTROW (R)
    DIV (R) DO DOUBLE (R)
    DROP (R) DUAL (R) DUMPFILE
    DUPLICATE DYNAMIC EACH (R)
    ELSE (R) ELSEIF (R) ENABLE
    ENCLOSED (R) ENCRYPTION[e] END
    ENDS ENGINE ENGINES
    ENUM ERROR ERRORS
    ESCAPE ESCAPED (R) EVENT
    EVENTS EVERY EXCHANGE
    EXECUTE EXISTS (R) EXIT (R)
    EXPANSION EXPIRE EXPLAIN (R)
    EXPORT EXTENDED EXTENT_SIZE
    FALSE (R) FAST FAULTS
    FETCH (R) FIELDS FILE
    FILE_BLOCK_SIZE[f] FILTER[g] FIRST
    FIXED FLOAT (R) FLOAT4 (R)
    FLOAT8 (R) FLUSH FOLLOWS[h]
    FOR (R) FORCE (R) FOREIGN (R)
    FORMAT FOUND FROM (R)
    FULL FULLTEXT (R) FUNCTION
    GENERAL GENERATED[i] (R) GEOMETRY
    GEOMETRYCOLLECTION GET (R) GET_FORMAT
    GLOBAL GRANT (R) GRANTS
    GROUP (R) GROUP_REPLICATION[j] HANDLER
    HASH HAVING (R) HELP
    HIGH_PRIORITY (R) HOST HOSTS
    HOUR HOUR_MICROSECOND (R) HOUR_MINUTE (R)
    HOUR_SECOND (R) IDENTIFIED IF (R)
    IGNORE (R) IGNORE_SERVER_IDS IMPORT
    IN (R) INDEX (R) INDEXES
    INFILE (R) INITIAL_SIZE INNER (R)
    INOUT (R) INSENSITIVE (R) INSERT (R)
    INSERT_METHOD INSTALL INSTANCE[k]
    INT (R) INT1 (R) INT2 (R)
    INT3 (R) INT4 (R) INT8 (R)
    INTEGER (R) INTERVAL (R) INTO (R)
    INVOKER IO IO_AFTER_GTIDS (R)
    IO_BEFORE_GTIDS (R) IO_THREAD IPC
    IS (R) ISOLATION ISSUER
    ITERATE (R) JOIN (R) JSON[l]
    KEY (R) KEYS (R) KEY_BLOCK_SIZE
    KILL (R) LANGUAGE LAST
    LEADING (R) LEAVE (R) LEAVES
    LEFT (R) LESS LEVEL
    LIKE (R) LIMIT (R) LINEAR (R)
    LINES (R) LINESTRING LIST
    LOAD (R) LOCAL LOCALTIME (R)
    LOCALTIMESTAMP (R) LOCK (R) LOCKS
    LOGFILE LOGS LONG (R)
    LONGBLOB (R) LONGTEXT (R) LOOP (R)
    LOW_PRIORITY (R) MASTER MASTER_AUTO_POSITION
    MASTER_BIND (R) MASTER_CONNECT_RETRY MASTER_DELAY
    MASTER_HEARTBEAT_PERIOD MASTER_HOST MASTER_LOG_FILE
    MASTER_LOG_POS MASTER_PASSWORD MASTER_PORT
    MASTER_RETRY_COUNT MASTER_SERVER_ID MASTER_SSL
    MASTER_SSL_CA MASTER_SSL_CAPATH MASTER_SSL_CERT
    MASTER_SSL_CIPHER MASTER_SSL_CRL MASTER_SSL_CRLPATH
    MASTER_SSL_KEY MASTER_SSL_VERIFY_SERVER_CERT (R) MASTER_TLS_VERSION[m]
    MASTER_USER MATCH (R) MAXVALUE (R)
    MAX_CONNECTIONS_PER_HOUR MAX_QUERIES_PER_HOUR MAX_ROWS
    MAX_SIZE MAX_STATEMENT_TIME[n] MAX_UPDATES_PER_HOUR
    MAX_USER_CONNECTIONS MEDIUM MEDIUMBLOB (R)
    MEDIUMINT (R) MEDIUMTEXT (R) MEMORY
    MERGE MESSAGE_TEXT MICROSECOND
    MIDDLEINT (R) MIGRATE MINUTE
    MINUTE_MICROSECOND (R) MINUTE_SECOND (R) MIN_ROWS
    MOD (R) MODE MODIFIES (R)
    MODIFY MONTH MULTILINESTRING
    MULTIPOINT MULTIPOLYGON MUTEX
    MYSQL_ERRNO NAME NAMES
    NATIONAL NATURAL (R) NCHAR
    NDB NDBCLUSTER NEVER[o]
    NEW NEXT NO
    NODEGROUP NONBLOCKING[p] NONE
    NOT (R) NO_WAIT NO_WRITE_TO_BINLOG (R)
    NULL (R) NUMBER NUMERIC (R)
    NVARCHAR OFFSET OLD_PASSWORD[q]
    ON (R) ONE ONLY
    OPEN OPTIMIZE (R) OPTIMIZER_COSTS[r] (R)
    OPTION (R) OPTIONALLY (R) OPTIONS
    OR (R) ORDER (R) OUT (R)
    OUTER (R) OUTFILE (R) OWNER
    PACK_KEYS PAGE PARSER
    PARSE_GCOL_EXPR[s] PARTIAL PARTITION (R)
    PARTITIONING PARTITIONS PASSWORD
    PHASE PLUGIN PLUGINS
    PLUGIN_DIR POINT POLYGON
    PORT PRECEDES[t] PRECISION (R)
    PREPARE PRESERVE PREV
    PRIMARY (R) PRIVILEGES PROCEDURE (R)
    PROCESSLIST PROFILE PROFILES
    PROXY PURGE (R) QUARTER
    QUERY QUICK RANGE (R)
    READ (R) READS (R) READ_ONLY
    READ_WRITE (R) REAL (R) REBUILD
    RECOVER REDOFILE REDO_BUFFER_SIZE
    REDUNDANT REFERENCES (R) REGEXP (R)
    RELAY RELAYLOG RELAY_LOG_FILE
    RELAY_LOG_POS RELAY_THREAD RELEASE (R)
    RELOAD REMOVE RENAME (R)
    REORGANIZE REPAIR REPEAT (R)
    REPEATABLE REPLACE (R) REPLICATE_DO_DB[u]
    REPLICATE_DO_TABLE[v] REPLICATE_IGNORE_DB[w] REPLICATE_IGNORE_TABLE[x]
    REPLICATE_REWRITE_DB[y] REPLICATE_WILD_DO_TABLE[z] REPLICATE_WILD_IGNORE_TABLE[aa]
    REPLICATION REQUIRE (R) RESET
    RESIGNAL (R) RESTORE RESTRICT (R)
    RESUME RETURN (R) RETURNED_SQLSTATE
    RETURNS REVERSE REVOKE (R)
    RIGHT (R) RLIKE (R) ROLLBACK
    ROLLUP ROTATE[ab] ROUTINE
    ROW ROWS ROW_COUNT
    ROW_FORMAT RTREE SAVEPOINT
    SCHEDULE SCHEMA (R) SCHEMAS (R)
    SCHEMA_NAME SECOND SECOND_MICROSECOND (R)
    SECURITY SELECT (R) SENSITIVE (R)
    SEPARATOR (R) SERIAL SERIALIZABLE
    SERVER SESSION SET (R)
    SHARE SHOW (R) SHUTDOWN
    SIGNAL (R) SIGNED SIMPLE
    SLAVE SLOW SMALLINT (R)
    SNAPSHOT SOCKET SOME
    SONAME SOUNDS SOURCE
    SPATIAL (R) SPECIFIC (R) SQL (R)
    SQLEXCEPTION (R) SQLSTATE (R) SQLWARNING (R)
    SQL_AFTER_GTIDS SQL_AFTER_MTS_GAPS SQL_BEFORE_GTIDS
    SQL_BIG_RESULT (R) SQL_BUFFER_RESULT SQL_CACHE
    SQL_CALC_FOUND_ROWS (R) SQL_NO_CACHE SQL_SMALL_RESULT (R)
    SQL_THREAD SQL_TSI_DAY SQL_TSI_HOUR
    SQL_TSI_MINUTE SQL_TSI_MONTH SQL_TSI_QUARTER
    SQL_TSI_SECOND SQL_TSI_WEEK SQL_TSI_YEAR
    SSL (R) STACKED START
    STARTING (R) STARTS STATS_AUTO_RECALC
    STATS_PERSISTENT STATS_SAMPLE_PAGES STATUS
    STOP STORAGE STORED[ac] (R)
    STRAIGHT_JOIN (R) STRING SUBCLASS_ORIGIN
    SUBJECT SUBPARTITION SUBPARTITIONS
    SUPER SUSPEND SWAPS
    SWITCHES TABLE (R) TABLES
    TABLESPACE TABLE_CHECKSUM TABLE_NAME
    TEMPORARY TEMPTABLE TERMINATED (R)
    TEXT THAN THEN (R)
    TIME TIMESTAMP TIMESTAMPADD
    TIMESTAMPDIFF TINYBLOB (R) TINYINT (R)
    TINYTEXT (R) TO (R) TRAILING (R)
    TRANSACTION TRIGGER (R) TRIGGERS
    TRUE (R) TRUNCATE TYPE
    TYPES UNCOMMITTED UNDEFINED
    UNDO (R) UNDOFILE UNDO_BUFFER_SIZE
    UNICODE UNINSTALL UNION (R)
    UNIQUE (R) UNKNOWN UNLOCK (R)
    UNSIGNED (R) UNTIL UPDATE (R)
    UPGRADE USAGE (R) USE (R)
    USER USER_RESOURCES USE_FRM
    USING (R) UTC_DATE (R) UTC_TIME (R)
    UTC_TIMESTAMP (R) VALIDATION[ad] VALUE
    VALUES (R) VARBINARY (R) VARCHAR (R)
    VARCHARACTER (R) VARIABLES VARYING (R)
    VIEW VIRTUAL[ae] (R) WAIT
    WARNINGS WEEK WEIGHT_STRING
    WHEN (R) WHERE (R) WHILE (R)
    WITH (R) WITHOUT[af] WORK
    WRAPPER WRITE (R) X509
    XA XID[ag] XML
    XOR (R) YEAR YEAR_MONTH (R)
    ZEROFILL (R)    

    Oracle

    select * from v$reserved_words order by keyword asc

    !
    !=
    
    (
    )
    *
    +
    ,
    -
    .
    /
    :
    ;
    
    
    =
    =
    =>
    >
    >=
    @
    A
    ABORT
    ABS
    ACCESS
    ACCESSED
    ACCOUNT
    ACOS
    ACTIVATE
    ACTIVE_COMPONENT
    ACTIVE_FUNCTION
    ACTIVE_TAG
    ADD
    ADD_COLUMN
    ADD_GROUP
    ADD_MONTHS
    ADJ_DATE
    ADMIN
    ADMINISTER
    ADMINISTRATOR
    ADVISE
    ADVISOR
    AFTER
    ALIAS
    ALL
    ALLOCATE
    ALLOW
    ALL_ROWS
    ALTER
    ALWAYS
    ANALYZE
    ANCILLARY
    AND
    AND_EQUAL
    ANTIJOIN
    ANY
    ANYSCHEMA
    APPEND
    APPENDCHILDXML
    APPEND_VALUES
    APPLY
    ARCHIVE
    ARCHIVELOG
    ARRAY
    AS
    ASC
    ASCII
    ASCIISTR
    ASIN
    ASSEMBLY
    ASSOCIATE
    ASYNC
    ASYNCHRONOUS
    AT
    ATAN
    ATAN2
    ATTRIBUTE
    ATTRIBUTES
    AUDIT
    AUTHENTICATED
    AUTHENTICATION
    AUTHID
    AUTHORIZATION
    AUTO
    AUTOALLOCATE
    AUTOEXTEND
    AUTOMATIC
    AVAILABILITY
    AVG
    BACKUP
    BASIC
    BASICFILE
    BATCH
    BECOME
    BEFORE
    BEGIN
    BEGIN_OUTLINE_DATA
    BEHALF
    BETWEEN
    BFILE
    BFILENAME
    BIGFILE
    BINARY
    BINARY_DOUBLE
    BINARY_DOUBLE_INFINITY
    BINARY_DOUBLE_NAN
    BINARY_FLOAT
    BINARY_FLOAT_INFINITY
    BINARY_FLOAT_NAN
    BINDING
    BIND_AWARE
    BIN_TO_NUM
    BITAND
    BITMAP
    BITMAPS
    BITMAP_TREE
    BITS
    BLOB
    BLOCK
    BLOCKS
    BLOCKSIZE
    BLOCK_RANGE
    BODY
    BOTH
    BOUND
    BRANCH
    BREADTH
    BROADCAST
    BUFFER
    BUFFER_CACHE
    BUFFER_POOL
    BUILD
    BULK
    BY
    BYPASS_RECURSIVE_CHECK
    BYPASS_UJVC
    BYTE
    CACHE
    CACHE_CB
    CACHE_INSTANCES
    CACHE_TEMP_TABLE
    CALL
    CANCEL
    CARDINALITY
    CASCADE
    CASE
    CAST
    CATEGORY
    CEIL
    CELL_FLASH_CACHE
    CERTIFICATE
    CFILE
    CHAINED
    CHANGE
    CHANGE_DUPKEY_ERROR_INDEX
    CHAR
    CHARACTER
    CHARTOROWID
    CHAR_CS
    CHECK
    CHECKPOINT
    CHECK_ACL_REWRITE
    CHILD
    CHOOSE
    CHR
    CHUNK
    CLASS
    CLEAR
    CLOB
    CLONE
    CLOSE
    CLOSE_CACHED_OPEN_CURSORS
    CLUSTER
    CLUSTERING_FACTOR
    CLUSTER_ID
    CLUSTER_PROBABILITY
    CLUSTER_SET
    COALESCE
    COALESCE_SQ
    COARSE
    COLD
    COLLECT
    COLUMN
    COLUMNAR
    COLUMNS
    COLUMN_AUTH_INDICATOR
    COLUMN_STATS
    COLUMN_VALUE
    COMMENT
    COMMIT
    COMMITTED
    COMPACT
    COMPATIBILITY
    COMPILE
    COMPLETE
    COMPLIANCE
    COMPOSE
    COMPOSITE
    COMPOSITE_LIMIT
    COMPOUND
    COMPRESS
    COMPUTE
    CONCAT
    CONFIRM
    CONFORMING
    CONNECT
    CONNECT_BY_CB_WHR_ONLY
    CONNECT_BY_COMBINE_SW
    CONNECT_BY_COST_BASED
    CONNECT_BY_ELIM_DUPS
    CONNECT_BY_FILTERING
    CONNECT_BY_ISCYCLE
    CONNECT_BY_ISLEAF
    CONNECT_BY_ROOT
    CONNECT_TIME
    CONSIDER
    CONSISTENT
    CONST
    CONSTANT
    CONSTRAINT
    CONSTRAINTS
    CONTAINER
    CONTENT
    CONTENTS
    CONTEXT
    CONTINUE
    CONTROLFILE
    CONVERT
    CORR
    CORRUPTION
    CORRUPT_XID
    CORRUPT_XID_ALL
    CORR_K
    CORR_S
    COS
    COSH
    COST
    COST_XML_QUERY_REWRITE
    COUNT
    COVAR_POP
    COVAR_SAMP
    CO_AUTH_IND
    CPU_COSTING
    CPU_PER_CALL
    CPU_PER_SESSION
    CRASH
    CREATE
    CREATE_STORED_OUTLINES
    CREATION
    CROSS
    CROSSEDITION
    CSCONVERT
    CUBE
    CUBE_GB
    CUME_DIST
    CUME_DISTM
    CURRENT
    CURRENTV
    CURRENT_DATE
    CURRENT_SCHEMA
    CURRENT_TIME
    CURRENT_TIMESTAMP
    CURRENT_USER
    CURSOR
    CURSOR_SHARING_EXACT
    CURSOR_SPECIFIC_SEGMENT
    CV
    CYCLE
    D
    DANGLING
    DATA
    DATABASE
    DATABASE_DEFAULT
    DATAFILE
    DATAFILES
    DATAOBJNO
    DATAOBJ_TO_PARTITION
    DATE
    DATE_MODE
    DAY
    DBA
    DBA_RECYCLEBIN
    DBMS_STATS
    DBTIMEZONE
    DB_ROLE_CHANGE
    DB_VERSION
    DDL
    DEALLOCATE
    DEBUG
    DEBUGGER
    DEC
    DECIMAL
    DECLARE
    DECODE
    DECOMPOSE
    DECR
    DECREMENT
    DECRYPT
    DEDUPLICATE
    DEFAULT
    DEFAULTS
    DEFERRABLE
    DEFERRED
    DEFINED
    DEFINER
    DEGREE
    DELAY
    DELETE
    DELETEXML
    DEMAND
    DENSE_RANK
    DENSE_RANKM
    DEPENDENT
    DEPTH
    DEQUEUE
    DEREF
    DEREF_NO_REWRITE
    DESC
    DETACHED
    DETERMINES
    DICTIONARY
    DIMENSION
    DIRECTORY
    DIRECT_LOAD
    DISABLE
    DISABLE_PRESET
    DISABLE_RPKE
    DISALLOW
    DISASSOCIATE
    DISCONNECT
    DISK
    DISKGROUP
    DISKS
    DISMOUNT
    DISTINCT
    DISTINGUISHED
    DISTRIBUTED
    DML
    DML_UPDATE
    DOCFIDELITY
    DOCUMENT
    DOMAIN_INDEX_FILTER
    DOMAIN_INDEX_NO_SORT
    DOMAIN_INDEX_SORT
    DOUBLE
    DOWNGRADE
    DRIVING_SITE
    DROP
    DROP_COLUMN
    DROP_GROUP
    DST_UPGRADE_INSERT_CONV
    DUMP
    DYNAMIC
    DYNAMIC_SAMPLING
    DYNAMIC_SAMPLING_EST_CDN
    E
    EACH
    EDITION
    EDITIONING
    EDITIONS
    ELEMENT
    ELIMINATE_JOIN
    ELIMINATE_OBY
    ELIMINATE_OUTER_JOIN
    ELSE
    EMPTY
    EMPTY_BLOB
    EMPTY_CLOB
    ENABLE
    ENABLE_PRESET
    ENCODING
    ENCRYPT
    ENCRYPTION
    END
    END_OUTLINE_DATA
    ENFORCE
    ENFORCED
    ENQUEUE
    ENTERPRISE
    ENTITYESCAPING
    ENTRY
    ERROR
    ERRORS
    ERROR_ARGUMENT
    ERROR_ON_OVERLAP_TIME
    ESCAPE
    ESTIMATE
    EVALNAME
    EVALUATION
    EVENTS
    EVERY
    EXCEPT
    EXCEPTIONS
    EXCHANGE
    EXCLUDE
    EXCLUDING
    EXCLUSIVE
    EXECUTE
    EXEMPT
    EXISTS
    EXISTSNODE
    EXP
    EXPAND_GSET_TO_UNION
    EXPAND_TABLE
    EXPIRE
    EXPLAIN
    EXPLOSION
    EXPORT
    EXPR_CORR_CHECK
    EXTENDS
    EXTENT
    EXTENTS
    EXTERNAL
    EXTERNALLY
    EXTRA
    EXTRACT
    EXTRACTVALUE
    FACILITY
    FACT
    FACTORIZE_JOIN
    FAILED
    FAILED_LOGIN_ATTEMPTS
    FAILGROUP
    FALSE
    FAST
    FBTSCAN
    FEATURE_ID
    FEATURE_SET
    FEATURE_VALUE
    FILE
    FILESYSTEM_LIKE_LOGGING
    FILTER
    FINAL
    FINE
    FINISH
    FIRST
    FIRSTM
    FIRST_ROWS
    FIRST_VALUE
    FLAGGER
    FLASHBACK
    FLASH_CACHE
    FLOAT
    FLOB
    FLOOR
    FLUSH
    FOLDER
    FOLLOWING
    FOLLOWS
    FOR
    FORCE
    FORCE_XML_QUERY_REWRITE
    FOREIGN
    FOREVER
    FORWARD
    FREELIST
    FREELISTS
    FREEPOOLS
    FRESH
    FROM
    FROM_TZ
    FULL
    FUNCTION
    FUNCTIONS
    G
    GATHER_PLAN_STATISTICS
    GBY_CONC_ROLLUP
    GBY_PUSHDOWN
    GENERATED
    GLOBAL
    GLOBALLY
    GLOBAL_NAME
    GLOBAL_TOPIC_ENABLED
    GRANT
    GREATEST
    GROUP
    GROUPING
    GROUPING_ID
    GROUPS
    GROUP_BY
    GROUP_ID
    GUARANTEE
    GUARANTEED
    GUARD
    H
    HASH
    HASHKEYS
    HASH_AJ
    HASH_SJ
    HAVING
    HEADER
    HEAP
    HELP
    HEXTORAW
    HEXTOREF
    HIDDEN
    HIDE
    HIERARCHY
    HIGH
    HINTSET_BEGIN
    HINTSET_END
    HOT
    HOUR
    HWM_BROKERED
    HYBRID
    ID
    IDENTIFIED
    IDENTIFIER
    IDENTITY
    IDGENERATORS
    IDLE_TIME
    IF
    IGNORE
    IGNORE_OPTIM_EMBEDDED_HINTS
    IGNORE_ROW_ON_DUPKEY_INDEX
    IGNORE_WHERE_CLAUSE
    IMMEDIATE
    IMPACT
    IMPORT
    IN
    INCLUDE
    INCLUDE_VERSION
    INCLUDING
    INCR
    INCREMENT
    INCREMENTAL
    INDENT
    INDEX
    INDEXED
    INDEXES
    INDEXTYPE
    INDEXTYPES
    INDEX_ASC
    INDEX_COMBINE
    INDEX_DESC
    INDEX_FFS
    INDEX_FILTER
    INDEX_JOIN
    INDEX_ROWS
    INDEX_RRS
    INDEX_RS
    INDEX_RS_ASC
    INDEX_RS_DESC
    INDEX_SCAN
    INDEX_SKIP_SCAN
    INDEX_SS
    INDEX_SS_ASC
    INDEX_SS_DESC
    INDEX_STATS
    INDICATOR
    INFINITE
    INFORMATIONAL
    INITCAP
    INITIAL
    INITIALIZED
    INITIALLY
    INITRANS
    INLINE
    INLINE_XMLTYPE_NT
    INNER
    INSERT
    INSERTCHILDXML
    INSERTCHILDXMLAFTER
    INSERTCHILDXMLBEFORE
    INSERTXMLAFTER
    INSERTXMLBEFORE
    INSTANCE
    INSTANCES
    INSTANTIABLE
    INSTANTLY
    INSTEAD
    INSTR
    INSTR2
    INSTR4
    INSTRB
    INSTRC
    INT
    INTEGER
    INTERMEDIATE
    INTERNAL_CONVERT
    INTERNAL_USE
    INTERPRETED
    INTERSECT
    INTERVAL
    INTO
    INVALIDATE
    INVISIBLE
    IN_MEMORY_METADATA
    IN_XQUERY
    IS
    ISOLATION
    ISOLATION_LEVEL
    ITERATE
    ITERATION_NUMBER
    JAVA
    JOB
    JOIN
    K
    KEEP
    KEEP_DUPLICATES
    KERBEROS
    KEY
    KEYS
    KEYSIZE
    KEY_LENGTH
    KILL
    LAG
    LAST
    LAST_DAY
    LAST_VALUE
    LATERAL
    LAYER
    LDAP_REGISTRATION
    LDAP_REGISTRATION_ENABLED
    LDAP_REG_SYNC_INTERVAL
    LEAD
    LEADING
    LEAST
    LEFT
    LENGTH
    LENGTH2
    LENGTH4
    LENGTHB
    LENGTHC
    LESS
    LEVEL
    LEVELS
    LIBRARY
    LIFE
    LIFETIME
    LIKE
    LIKE2
    LIKE4
    LIKEC
    LIKE_EXPAND
    LIMIT
    LINK
    LIST
    LISTAGG
    LN
    LNNVL
    LOB
    LOBNVL
    LOBS
    LOCAL
    LOCALTIME
    LOCALTIMESTAMP
    LOCAL_INDEXES
    LOCATION
    LOCATOR
    LOCK
    LOCKED
    LOG
    LOGFILE
    LOGFILES
    LOGGING
    LOGICAL
    LOGICAL_READS_PER_CALL
    LOGICAL_READS_PER_SESSION
    LOGOFF
    LOGON
    LONG
    LOW
    LOWER
    LPAD
    LTRIM
    M
    MAIN
    MAKE_REF
    MANAGE
    MANAGED
    MANAGEMENT
    MANUAL
    MAPPING
    MASTER
    MATCHED
    MATERIALIZE
    MATERIALIZED
    MAX
    MAXARCHLOGS
    MAXDATAFILES
    MAXEXTENTS
    MAXIMIZE
    MAXINSTANCES
    MAXLOGFILES
    MAXLOGHISTORY
    MAXLOGMEMBERS
    MAXSIZE
    MAXTRANS
    MAXVALUE
    MEASURE
    MEASURES
    MEDIAN
    MEDIUM
    MEMBER
    MEMORY
    MERGE
    MERGE$ACTIONS
    MERGE_AJ
    MERGE_CONST_ON
    MERGE_SJ
    METHOD
    MIGRATE
    MIGRATION
    MIN
    MINEXTENTS
    MINIMIZE
    MINIMUM
    MINING
    MINUS
    MINUS_NULL
    MINUTE
    MINVALUE
    MIRROR
    MIRRORCOLD
    MIRRORHOT
    MLSLABEL
    MOD
    MODE
    MODEL
    MODEL_COMPILE_SUBQUERY
    MODEL_DONTVERIFY_UNIQUENESS
    MODEL_DYNAMIC_SUBQUERY
    MODEL_MIN_ANALYSIS
    MODEL_NO_ANALYSIS
    MODEL_PBY
    MODEL_PUSH_REF
    MODIFY
    MONITOR
    MONITORING
    MONTH
    MONTHS_BETWEEN
    MOUNT
    MOUNTPATH
    MOVE
    MOVEMENT
    MULTISET
    MV_MERGE
    NAME
    NAMED
    NAMESPACE
    NAN
    NANVL
    NATIONAL
    NATIVE
    NATIVE_FULL_OUTER_JOIN
    NATURAL
    NAV
    NCHAR
    NCHAR_CS
    NCHR
    NCLOB
    NEEDED
    NESTED
    NESTED_TABLE_FAST_INSERT
    NESTED_TABLE_GET_REFS
    NESTED_TABLE_ID
    NESTED_TABLE_SET_REFS
    NESTED_TABLE_SET_SETID
    NETWORK
    NEVER
    NEW
    NEW_TIME
    NEXT
    NEXT_DAY
    NLJ_BATCHING
    NLJ_INDEX_FILTER
    NLJ_INDEX_SCAN
    NLJ_PREFETCH
    NLSSORT
    NLS_CALENDAR
    NLS_CHARACTERSET
    NLS_CHARSET_DECL_LEN
    NLS_CHARSET_ID
    NLS_CHARSET_NAME
    NLS_COMP
    NLS_CURRENCY
    NLS_DATE_FORMAT
    NLS_DATE_LANGUAGE
    NLS_INITCAP
    NLS_ISO_CURRENCY
    NLS_LANG
    NLS_LANGUAGE
    NLS_LENGTH_SEMANTICS
    NLS_LOWER
    NLS_NCHAR_CONV_EXCP
    NLS_NUMERIC_CHARACTERS
    NLS_SORT
    NLS_SPECIAL_CHARS
    NLS_TERRITORY
    NLS_UPPER
    NL_AJ
    NL_SJ
    NO
    NOAPPEND
    NOARCHIVELOG
    NOAUDIT
    NOCACHE
    NOCOMPRESS
    NOCPU_COSTING
    NOCYCLE
    NODELAY
    NOENTITYESCAPING
    NOFORCE
    NOGUARANTEE
    NOLOCAL
    NOLOGGING
    NOMAPPING
    NOMAXVALUE
    NOMINIMIZE
    NOMINVALUE
    NOMONITORING
    NONE
    NONSCHEMA
    NOORDER
    NOOVERRIDE
    NOPARALLEL
    NOPARALLEL_INDEX
    NORELY
    NOREPAIR
    NORESETLOGS
    NOREVERSE
    NOREWRITE
    NORMAL
    NOROWDEPENDENCIES
    NOSCHEMACHECK
    NOSEGMENT
    NOSORT
    NOSTRICT
    NOSWITCH
    NOT
    NOTHING
    NOTIFICATION
    NOVALIDATE
    NOWAIT
    NO_ACCESS
    NO_BASETABLE_MULTIMV_REWRITE
    NO_BIND_AWARE
    NO_BUFFER
    NO_CARTESIAN
    NO_CHECK_ACL_REWRITE
    NO_COALESCE_SQ
    NO_CONNECT_BY_CB_WHR_ONLY
    NO_CONNECT_BY_COMBINE_SW
    NO_CONNECT_BY_COST_BASED
    NO_CONNECT_BY_ELIM_DUPS
    NO_CONNECT_BY_FILTERING
    NO_COST_XML_QUERY_REWRITE
    NO_CPU_COSTING
    NO_DOMAIN_INDEX_FILTER
    NO_DST_UPGRADE_INSERT_CONV
    NO_ELIMINATE_JOIN
    NO_ELIMINATE_OBY
    NO_ELIMINATE_OUTER_JOIN
    NO_EXPAND
    NO_EXPAND_GSET_TO_UNION
    NO_EXPAND_TABLE
    NO_FACT
    NO_FACTORIZE_JOIN
    NO_FILTERING
    NO_GBY_PUSHDOWN
    NO_INDEX
    NO_INDEX_FFS
    NO_INDEX_SS
    NO_LOAD
    NO_MERGE
    NO_MODEL_PUSH_REF
    NO_MONITOR
    NO_MONITORING
    NO_MULTIMV_REWRITE
    NO_NATIVE_FULL_OUTER_JOIN
    NO_NLJ_BATCHING
    NO_NLJ_PREFETCH
    NO_ORDER_ROLLUPS
    NO_OUTER_JOIN_TO_INNER
    NO_PARALLEL
    NO_PARALLEL_INDEX
    NO_PARTIAL_COMMIT
    NO_PLACE_DISTINCT
    NO_PLACE_GROUP_BY
    NO_PQ_MAP
    NO_PRUNE_GSETS
    NO_PULL_PRED
    NO_PUSH_PRED
    NO_PUSH_SUBQ
    NO_PX_JOIN_FILTER
    NO_QKN_BUFF
    NO_QUERY_TRANSFORMATION
    NO_REF_CASCADE
    NO_RESULT_CACHE
    NO_REWRITE
    NO_SEMIJOIN
    NO_SET_TO_JOIN
    NO_SQL_TUNE
    NO_STAR_TRANSFORMATION
    NO_STATEMENT_QUEUING
    NO_STATS_GSETS
    NO_SUBQUERY_PRUNING
    NO_SUBSTRB_PAD
    NO_SWAP_JOIN_INPUTS
    NO_TEMP_TABLE
    NO_TRANSFORM_DISTINCT_AGG
    NO_UNNEST
    NO_USE_HASH
    NO_USE_HASH_AGGREGATION
    NO_USE_INVISIBLE_INDEXES
    NO_USE_MERGE
    NO_USE_NL
    NO_XMLINDEX_REWRITE
    NO_XMLINDEX_REWRITE_IN_SELECT
    NO_XML_DML_REWRITE
    NO_XML_QUERY_REWRITE
    NTH_VALUE
    NTILE
    NULL
    NULLIF
    NULLS
    NUMBER
    NUMERIC
    NUMTODSINTERVAL
    NUMTOYMINTERVAL
    NUM_INDEX_KEYS
    NVARCHAR2
    NVL
    NVL2
    OBJECT
    OBJECTTOXML
    OBJNO
    OBJNO_REUSE
    OCCURENCES
    OF
    OFF
    OFFLINE
    OID
    OIDINDEX
    OLAP
    OLD
    OLD_PUSH_PRED
    OLTP
    ON
    ONLINE
    ONLY
    OPAQUE
    OPAQUE_TRANSFORM
    OPAQUE_XCANONICAL
    OPCODE
    OPEN
    OPERATIONS
    OPERATOR
    OPTIMAL
    OPTIMIZER_FEATURES_ENABLE
    OPTIMIZER_GOAL
    OPTION
    OPT_ESTIMATE
    OPT_PARAM
    OR
    ORADEBUG
    ORA_BRANCH
    ORA_CHECKACL
    ORA_DST_AFFECTED
    ORA_DST_CONVERT
    ORA_DST_ERROR
    ORA_GET_ACLIDS
    ORA_GET_PRIVILEGES
    ORA_HASH
    ORA_ROWSCN
    ORA_ROWSCN_RAW
    ORA_ROWVERSION
    ORA_TABVERSION
    ORDER
    ORDERED
    ORDERED_PREDICATES
    ORDINALITY
    ORGANIZATION
    OR_EXPAND
    OR_PREDICATES
    OTHER
    OUTER
    OUTER_JOIN_TO_INNER
    OUTLINE
    OUTLINE_LEAF
    OUT_OF_LINE
    OVER
    OVERFLOW
    OVERFLOW_NOMOVE
    OVERLAPS
    OWN
    OWNER
    OWNERSHIP
    P
    PACKAGE
    PACKAGES
    PARALLEL
    PARALLEL_INDEX
    PARAM
    PARAMETERS
    PARENT
    PARITY
    PART$NUM$INST
    PARTIALLY
    PARTITION
    PARTITIONS
    PARTITION_HASH
    PARTITION_LIST
    PARTITION_RANGE
    PASSING
    PASSWORD
    PASSWORD_GRACE_TIME
    PASSWORD_LIFE_TIME
    PASSWORD_LOCK_TIME
    PASSWORD_REUSE_MAX
    PASSWORD_REUSE_TIME
    PASSWORD_VERIFY_FUNCTION
    PATH
    PATHS
    PBL_HS_BEGIN
    PBL_HS_END
    PCTFREE
    PCTINCREASE
    PCTTHRESHOLD
    PCTUSED
    PCTVERSION
    PENDING
    PERCENT
    PERCENTILE_CONT
    PERCENTILE_DISC
    PERCENT_RANK
    PERCENT_RANKM
    PERFORMANCE
    PERMANENT
    PERMISSION
    PFILE
    PHYSICAL
    PIKEY
    PIVOT
    PIV_GB
    PIV_SSF
    PLACE_DISTINCT
    PLACE_GROUP_BY
    PLAN
    PLSCOPE_SETTINGS
    PLSQL_CCFLAGS
    PLSQL_CODE_TYPE
    PLSQL_DEBUG
    PLSQL_OPTIMIZE_LEVEL
    PLSQL_WARNINGS
    POINT
    POLICY
    POST_TRANSACTION
    POWER
    POWERMULTISET
    POWERMULTISET_BY_CARDINALITY
    PQ_DISTRIBUTE
    PQ_MAP
    PQ_NOMAP
    PREBUILT
    PRECEDES
    PRECEDING
    PRECISION
    PRECOMPUTE_SUBQUERY
    PREDICATE_REORDERS
    PREDICTION
    PREDICTION_BOUNDS
    PREDICTION_COST
    PREDICTION_DETAILS
    PREDICTION_PROBABILITY
    PREDICTION_SET
    PREPARE
    PRESENT
    PRESENTNNV
    PRESENTV
    PRESERVE
    PRESERVE_OID
    PREVIOUS
    PRIMARY
    PRIOR
    PRIVATE
    PRIVATE_SGA
    PRIVILEGE
    PRIVILEGES
    PROCEDURAL
    PROCEDURE
    PROCESS
    PROFILE
    PROGRAM
    PROJECT
    PROPAGATE
    PROTECTED
    PROTECTION
    PUBLIC
    PULL_PRED
    PURGE
    PUSH_PRED
    PUSH_SUBQ
    PX_GRANULE
    PX_JOIN_FILTER
    QB_NAME
    QUERY
    QUERY_BLOCK
    QUEUE
    QUEUE_CURR
    QUEUE_ROWP
    QUIESCE
    QUORUM
    QUOTA
    RANDOM
    RANDOM_LOCAL
    RANGE
    RANK
    RANKM
    RAPIDLY
    RATIO_TO_REPORT
    RAW
    RAWTOHEX
    RAWTONHEX
    RBA
    RBO_OUTLINE
    RDBA
    READ
    READS
    REAL
    REBALANCE
    REBUILD
    RECORDS_PER_BLOCK
    RECOVER
    RECOVERABLE
    RECOVERY
    RECYCLE
    RECYCLEBIN
    REDO
    REDUCED
    REDUNDANCY
    REF
    REFERENCE
    REFERENCED
    REFERENCES
    REFERENCING
    REFRESH
    REFTOHEX
    REF_CASCADE_CURSOR
    REGEXP_COUNT
    REGEXP_INSTR
    REGEXP_LIKE
    REGEXP_REPLACE
    REGEXP_SUBSTR
    REGISTER
    REGR_AVGX
    REGR_AVGY
    REGR_COUNT
    REGR_INTERCEPT
    REGR_R2
    REGR_SLOPE
    REGR_SXX
    REGR_SXY
    REGR_SYY
    REGULAR
    REJECT
    REKEY
    RELATIONAL
    RELY
    REMAINDER
    REMOTE_MAPPED
    REMOVE
    RENAME
    REPAIR
    REPEAT
    REPLACE
    REPLICATION
    REQUIRED
    RESET
    RESETLOGS
    RESIZE
    RESOLVE
    RESOLVER
    RESOURCE
    RESPECT
    RESTORE
    RESTORE_AS_INTERVALS
    RESTRICT
    RESTRICTED
    RESTRICT_ALL_REF_CONS
    RESULT_CACHE
    RESUMABLE
    RESUME
    RETENTION
    RETRY_ON_ROW_CHANGE
    RETURN
    RETURNING
    REUSE
    REVERSE
    REVOKE
    REWRITE
    REWRITE_OR_ERROR
    RIGHT
    ROLE
    ROLES
    ROLLBACK
    ROLLING
    ROLLUP
    ROUND
    ROW
    ROWDEPENDENCIES
    ROWID
    ROWIDTOCHAR
    ROWIDTONCHAR
    ROWNUM
    ROWS
    ROW_LENGTH
    ROW_NUMBER
    RPAD
    RTRIM
    RULE
    RULES
    SALT
    SAMPLE
    SAVEPOINT
    SAVE_AS_INTERVALS
    SB4
    SCALE
    SCALE_ROWS
    SCAN
    SCAN_INSTANCES
    SCHEDULER
    SCHEMA
    SCHEMACHECK
    SCN
    SCN_ASCENDING
    SCOPE
    SD_ALL
    SD_INHIBIT
    SD_SHOW
    SEARCH
    SECOND
    SECUREFILE
    SECUREFILE_DBA
    SECURITY
    SEED
    SEGMENT
    SEG_BLOCK
    SEG_FILE
    SELECT
    SELECTIVITY
    SEMIJOIN
    SEMIJOIN_DRIVER
    SEQUENCE
    SEQUENCED
    SEQUENTIAL
    SERIALIZABLE
    SERVERERROR
    SESSION
    SESSIONS_PER_USER
    SESSIONTIMEZONE
    SESSIONTZNAME
    SESSION_CACHED_CURSORS
    SET
    SETS
    SETTINGS
    SET_TO_JOIN
    SEVERE
    SHARE
    SHARED
    SHARED_POOL
    SHOW
    SHRINK
    SHUTDOWN
    SIBLINGS
    SID
    SIGN
    SIGNAL_COMPONENT
    SIGNAL_FUNCTION
    SIMPLE
    SIN
    SINGLE
    SINGLETASK
    SINH
    SIZE
    SKIP
    SKIP_EXT_OPTIMIZER
    SKIP_UNQ_UNUSABLE_IDX
    SKIP_UNUSABLE_INDEXES
    SMALLFILE
    SMALLINT
    SNAPSHOT
    SOME
    SORT
    SOUNDEX
    SOURCE
    SPACE
    SPECIFICATION
    SPFILE
    SPLIT
    SPREADSHEET
    SQL
    SQLLDR
    SQL_TRACE
    SQRT
    STALE
    STANDALONE
    STANDBY
    STANDBY_MAX_DATA_DELAY
    STAR
    START
    STARTUP
    STAR_TRANSFORMATION
    STATEMENTS
    STATEMENT_ID
    STATEMENT_QUEUING
    STATIC
    STATISTICS
    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
    STOP
    STORAGE
    STORE
    STREAMS
    STRICT
    STRING
    STRIP
    STRIPE_COLUMNS
    STRIPE_WIDTH
    STRUCTURE
    SUBMULTISET
    SUBPARTITION
    SUBPARTITIONS
    SUBPARTITION_REL
    SUBQUERIES
    SUBQUERY_PRUNING
    SUBSTITUTABLE
    SUBSTR
    SUBSTR2
    SUBSTR4
    SUBSTRB
    SUBSTRC
    SUCCESSFUL
    SUM
    SUMMARY
    SUPPLEMENTAL
    SUSPEND
    SWAP_JOIN_INPUTS
    SWITCH
    SWITCHOVER
    SYNC
    SYNCHRONOUS
    SYNONYM
    SYSASM
    SYSAUX
    SYSDATE
    SYSDBA
    SYSOPER
    SYSTEM
    SYSTEM_DEFINED
    SYSTIMESTAMP
    SYS_AUDIT
    SYS_CHECKACL
    SYS_CONNECT_BY_PATH
    SYS_CONTEXT
    SYS_DBURIGEN
    SYS_DL_CURSOR
    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_FBT_INSDEL
    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_BITVEC
    SYS_OP_BL2R
    SYS_OP_BLOOM_FILTER
    SYS_OP_BLOOM_FILTER_LIST
    SYS_OP_C2C
    SYS_OP_CAST
    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_ENFORCE_NOT_NULL$
    SYS_OP_EXTRACT
    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_NOEXPAND
    SYS_OP_NTCIMG$
    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_PARALLEL_TXN
    SYS_PATHID_IS_ATTR
    SYS_PATHID_IS_NMSPC
    SYS_PATHID_LASTNAME
    SYS_PATHID_LASTNMSPC
    SYS_PATH_REVERSE
    SYS_PXQEXTRACT
    SYS_RID_ORDER
    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
    T
    TABLE
    TABLES
    TABLESPACE
    TABLESPACE_NO
    TABLE_STATS
    TABNO
    TAN
    TANH
    TBL$OR$IDX$PART$NUM
    TEMPFILE
    TEMPLATE
    TEMPORARY
    TEMP_TABLE
    TEST
    THAN
    THE
    THEN
    THREAD
    THROUGH
    TIME
    TIMEOUT
    TIMES
    TIMESTAMP
    TIMEZONE_ABBR
    TIMEZONE_HOUR
    TIMEZONE_MINUTE
    TIMEZONE_OFFSET
    TIMEZONE_REGION
    TIME_ZONE
    TIV_GB
    TIV_SSF
    TO
    TOPLEVEL
    TO_BINARY_DOUBLE
    TO_BINARY_FLOAT
    TO_BLOB
    TO_CHAR
    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
    TRACE
    TRACING
    TRACKING
    TRAILING
    TRANSACTION
    TRANSFORM_DISTINCT_AGG
    TRANSITION
    TRANSITIONAL
    TRANSLATE
    TREAT
    TRIGGER
    TRIGGERS
    TRIM
    TRUE
    TRUNC
    TRUNCATE
    TRUSTED
    TUNING
    TX
    TYPE
    TYPES
    TZ_OFFSET
    U
    UB2
    UBA
    UID
    UNARCHIVED
    UNBOUND
    UNBOUNDED
    UNDER
    UNDO
    UNDROP
    UNIFORM
    UNION
    UNIQUE
    UNISTR
    UNLIMITED
    UNLOCK
    UNNEST
    UNPACKED
    UNPIVOT
    UNPROTECTED
    UNQUIESCE
    UNRECOVERABLE
    UNRESTRICTED
    UNTIL
    UNUSABLE
    UNUSED
    UPDATABLE
    UPDATE
    UPDATED
    UPDATEXML
    UPD_INDEXES
    UPD_JOININDEX
    UPGRADE
    UPPER
    UPSERT
    UROWID
    USAGE
    USE
    USER
    USERENV
    USERGROUP
    USERS
    USER_DEFINED
    USER_RECYCLEBIN
    USE_ANTI
    USE_CONCAT
    USE_HASH
    USE_HASH_AGGREGATION
    USE_INVISIBLE_INDEXES
    USE_MERGE
    USE_MERGE_CARTESIAN
    USE_NL
    USE_NL_WITH_INDEX
    USE_PRIVATE_OUTLINES
    USE_SEMI
    USE_STORED_OUTLINES
    USE_TTT_FOR_GSETS
    USE_WEAK_NAME_RESL
    USING
    VALIDATE
    VALIDATION
    VALUE
    VALUES
    VARCHAR
    VARCHAR2
    VARIANCE
    VARRAY
    VARRAYS
    VARYING
    VAR_POP
    VAR_SAMP
    VECTOR_READ
    VECTOR_READ_TRACE
    VERIFY
    VERSION
    VERSIONING
    VERSIONS
    VERSIONS_ENDSCN
    VERSIONS_ENDTIME
    VERSIONS_OPERATION
    VERSIONS_STARTSCN
    VERSIONS_STARTTIME
    VERSIONS_XID
    VIEW
    VIRTUAL
    VISIBLE
    VOLUME
    VSIZE
    WAIT
    WALLET
    WELLFORMED
    WHEN
    WHENEVER
    WHERE
    WHITESPACE
    WIDTH_BUCKET
    WITH
    WITHIN
    WITHOUT
    WORK
    WRAPPED
    WRITE
    XID
    XML
    XMLATTRIBUTES
    XMLCAST
    XMLCDATA
    XMLCOLATTVAL
    XMLCOMMENT
    XMLCONCAT
    XMLDIFF
    XMLELEMENT
    XMLEXISTS
    XMLEXISTS2
    XMLFOREST
    XMLINDEX_REWRITE
    XMLINDEX_REWRITE_IN_SELECT
    XMLINDEX_SEL_IDX_TBL
    XMLISNODE
    XMLISVALID
    XMLNAMESPACES
    XMLPARSE
    XMLPATCH
    XMLPI
    XMLQUERY
    XMLROOT
    XMLSCHEMA
    XMLSERIALIZE
    XMLTABLE
    XMLTOOBJECT
    XMLTRANSFORM
    XMLTRANSFORMBLOB
    XMLTYPE
    XML_DML_RWT_STMT
    XPATHTABLE
    XS_SYS_CONTEXT
    X_DYN_PRUNE
    YEAR
    YES
    ZONE
    [
    ]
    ^
    {
    |
    }

    SQLServer

    https://msdn.microsoft.com/zh-cn/library/ms189822

    下表列出了 SQL Server 保留关键字。

    add

    EXTERNAL

    PROCEDURE

    ALL

    FETCH

    PUBLIC

    ALTER

    FILE

    RAISERROR

    And

    FILLFACTOR

    READ

    ANY

    FOR

    READTEXT

    As

    FOREIGN

    RECONFIGURE

    ASC

    FREETEXT

    REFERENCES

    AUTHORIZATION

    FREETEXTTABLE

    REPLICATION

    BACKUP

    from

    RESTORE

    BEGIN

    FULL

    RESTRICT

    BETWEEN

    FUNCTION

    RETURN

    BREAK

    GOTO

    REVERT

    BROWSE

    GRANT

    REVOKE

    BULK

    GROUP

    RIGHT

    BY

    HAVING

    ROLLBACK

    CASCADE

    HOLDLOCK

    ROWCOUNT

    Case

    IDENTITY

    ROWGUIDCOL

    CHECK

    IDENTITY_INSERT

    RULE

    CHECKPOINT

    IDENTITYCOL

    SAVE

    close

    IF

    SCHEMA

    CLUSTERED

    IN

    SECURITYAUDIT

    COALESCE

    INDEX

    SELECT

    COLLATE

    INNER

    SEMANTICKEYPHRASETABLE

    COLUMN

    INSERT

    SEMANTICSIMILARITYDETAILSTABLE

    COMMIT

    INTERSECT

    SEMANTICSIMILARITYTABLE

    COMPUTE

    INTO

    SESSION_USER

    CONSTRAINT

    is

    SET

    CONTAINS

    JOIN

    SETUSER

    CONTAINSTABLE

    KEY

    SHUTDOWN

    CONTINUE

    KILL

    SOME

    CONVERT

    LEFT

    STATISTICS

    CREATE

    LIKE

    SYSTEM_USER

    CROSS

    LINENO

    TABLE

    CURRENT

    LOAD

    TABLESAMPLE

    CURRENT_DATE

    MERGE

    TEXTSIZE

    CURRENT_TIME

    NATIONAL

    THEN

    CURRENT_TIMESTAMP

    NOCHECK

    目标

    CURRENT_USER

    NONCLUSTERED

    TOP

    CURSOR

    NOT

    TRAN

    DATABASE

    NULL

    TRANSACTION

    DBCC

    NULLIF

    Trigger

    DEALLOCATE

    OF

    TRUNCATE

    DECLARE

    OFF

    TRY_CONVERT

    DEFAULT

    OFFSETS

    TSEQUAL

    delete

    ON

    UNION

    DENY

    OPEN

    UNIQUE

    DESC

    OPENDATASOURCE

    UNPIVOT

    DISK

    OPENQUERY

    UPDATE

    DISTINCT

    OPENROWSET

    UPDATETEXT

    DISTRIBUTED

    OPENXML

    USE

    DOUBLE

    OPTION

    USER

    DROP

    OR

    VALUES

    DUMP

    ORDER

    VARYING

    Else

    OUTER

    View

    END

    OVER

    WAITFOR

    ERRLVL

    PERCENT

    WHEN

    ESCAPE

    PIVOT

    WHERE

    EXCEPT

    PLAN

    WHILE

    EXEC

    PRECISION

    WITH

    EXECUTE

    PRIMARY

    WITHIN GROUP

    EXISTS

    PRINT

    WRITETEXT

    EXIT

    PROC

     

     此外,ISO 标准定义了保留关键字列表。 不要使用 ISO 保留关键字作为对象名和标识符。 ODBC 保留关键字列表(如下表所示)与 ISO 保留关键字列表相同。

    注意

    ISO 标准保留关键字有时可能比 SQL Server 限制更多,有时则更少。 例如,ISO 保留关键字列表包含 INT。 SQL Server 不必将此区分为保留关键字。

    Transact-SQL 保留关键字可用作数据库或数据库对象(如表、列、视图等)的标识符或名称。 使用带引号的标识符或分隔标识符。 不限制将保留关键字用作变量和存储过程参数的名

    ODBC 保留关键字

    保留了下列关键字以用于 ODBC 函数调用。这些关键字根本不约束 SQL 语法;然而,为确保与支持核心 SQL 语法的驱动程序兼容,应用程序应避免使用这些关键字。

    下面是当前的 ODBC 保留关键字列表。

    ABSOLUTE

    EXEC

    OVERLAPS

    ACTION

    EXECUTE

    PAD

    ADA

    EXISTS

    PARTIAL

    ADD

    EXTERNAL

    PASCAL

    ALL

    EXTRACT

    POSITION

    ALLOCATE

    FALSE

    PRECISION

    ALTER

    FETCH

    PREPARE

    AND

    FIRST

    PRESERVE

    ANY

    FLOAT

    PRIMARY

    ARE

    FOR

    PRIOR

    AS

    FOREIGN

    PRIVILEGES

    ASC

    FORTRAN

    PROCEDURE

    ASSERTION

    FOUND

    PUBLIC

    AT

    FROM

    READ

    AUTHORIZATION

    FULL

    REAL

    AVG

    GET

    REFERENCES

    BEGIN

    GLOBAL

    RELATIVE

    BETWEEN

    GO

    RESTRICT

    BIT

    GOTO

    REVOKE

    BIT_LENGTH

    GRANT

    RIGHT

    BOTH

    GROUP

    ROLLBACK

    BY

    HAVING

    ROWS

    CASCADE

    HOUR

    SCHEMA

    CASCADED

    IDENTITY

    SCROLL

    CASE

    IMMEDIATE

    SECOND

    CAST

    IN

    SECTION

    CATALOG

    INCLUDE

    SELECT

    CHAR

    INDEX

    SESSION

    CHAR_LENGTH

    INDICATOR

    SESSION_USER

    CHARACTER

    INITIALLY

    SET

    CHARACTER_LENGTH

    INNER

    SIZE

    CHECK

    INPUT

    SMALLINT

    CLOSE

    INSENSITIVE

    SOME

    COALESCE

    INSERT

    SPACE

    COLLATE

    INT

    SQL

    COLLATION

    INTEGER

    SQLCA

    COLUMN

    INTERSECT

    SQLCODE

    COMMIT

    INTERVAL

    SQLERROR

    CONNECT

    INTO

    SQLSTATE

    CONNECTION

    IS

    SQLWARNING

    CONSTRAINT

    ISOLATION

    SUBSTRING

    CONSTRAINTS

    JOIN

    SUM

    CONTINUE

    KEY

    SYSTEM_USER

    CONVERT

    LANGUAGE

    TABLE

    CORRESPONDING

    LAST

    TEMPORARY

    COUNT

    LEADING

    THEN

    CREATE

    LEFT

    TIME

    CROSS

    LEVEL

    TIMESTAMP

    CURRENT

    LIKE

    TIMEZONE_HOUR

    CURRENT_DATE

    LOCAL

    TIMEZONE_MINUTE

    CURRENT_TIME

    LOWER

    TO

    CURRENT_TIMESTAMP

    MATCH

    TRAILING

    CURRENT_USER

    MAX

    TRANSACTION

    CURSOR

    MIN

    TRANSLATE

    DATE

    MINUTE

    TRANSLATION

    DAY

    MODULE

    TRIM

    DEALLOCATE

    MONTH

    TRUE

    DEC

    NAMES

    UNION

    DECIMAL

    NATIONAL

    UNIQUE

    DECLARE

    NATURAL

    UNKNOWN

    DEFAULT

    NCHAR

    UPDATE

    DEFERRABLE

    NEXT

    UPPER

    DEFERRED

    NO

    USAGE

    DELETE

    NONE

    USER

    DESC

    NOT

    USING

    DESCRIBE

    NULL

    VALUE

    DESCRIPTOR

    NULLIF

    VALUES

    DIAGNOSTICS

    NUMERIC

    VARCHAR

    DISCONNECT

    OCTET_LENGTH

    VARYING

    DISTINCT

    OF

    VIEW

    DOMAIN

    ON

    WHEN

    DOUBLE

    ONLY

    WHENEVER

    DROP

    OPEN

    WHERE

    ELSE

    OPTION

    WITH

    END

    OR

    WORK

    END-EXEC

    ORDER

    WRITE

    ESCAPE

    OUTER

    YEAR

    EXCEPT

    OUTPUT

    ZONE

    EXCEPTION

     

     

    将来的关键字

    下列关键字可能会在将来的 SQL Server 版本中保留使用,作为将来要实现的新功能。注意,不要使用这些关键字作为标识符。

    ABSOLUTE

    HOST

    RELATIVE

    ACTION

    HOUR

    RELEASE

    ADMIN

    IGNORE

    RESULT

    AFTER

    IMMEDIATE

    RETURNS

    AGGREGATE

    INDICATOR

    ROLE

    ALIAS

    INITIALIZE

    ROLLUP

    ALLOCATE

    INITIALLY

    ROUTINE

    ARE

    INOUT

    ROW

    ARRAY

    INPUT

    ROWS

    ASENSITIVE

    INT

    SAVEPOINT

    ASSERTION

    INTEGER

    SCROLL

    ASYMMETRIC

    INTERSECTION

    SCOPE

    AT

    INTERVAL

    SEARCH

    ATOMIC

    ISOLATION

    SECOND

    BEFORE

    ITERATE

    SECTION

    BINARY

    LANGUAGE

    SENSITIVE

    BIT

    LARGE

    SEQUENCE

    BLOB

    LAST

    SESSION

    BOOLEAN

    LATERAL

    SETS

    BOTH

    LEADING

    SIMILAR

    BREADTH

    LESS

    SIZE

    CALL

    LEVEL

    SMALLINT

    CALLED

    LIKE_REGEX

    SPACE

    CARDINALITY

    LIMIT

    SPECIFIC

    CASCADED

    LN

    SPECIFICTYPE

    CAST

    LOCAL

    SQL

    CATALOG

    LOCALTIME

    SQLEXCEPTION

    CHAR

    LOCALTIMESTAMP

    SQLSTATE

    CHARACTER

    LOCATOR

    SQLWARNING

    CLASS

    MAP

    START

    CLOB

    MATCH

    STATE

    COLLATION

    MEMBER

    STATEMENT

    COLLECT

    METHOD

    STATIC

    COMPLETION

    MINUTE

    STDDEV_POP

    CONDITION

    MOD

    STDDEV_SAMP

    CONNECT

    MODIFIES

    STRUCTURE

    CONNECTION

    MODIFY

    SUBMULTISET

    CONSTRAINTS

    MODULE

    SUBSTRING_REGEX

    CONSTRUCTOR

    MONTH

    SYMMETRIC

    CORR

    MULTISET

    SYSTEM

    CORRESPONDING

    NAMES

    TEMPORARY

    COVAR_POP

    NATURAL

    TERMINATE

    COVAR_SAMP

    NCHAR

    THAN

    CUBE

    NCLOB

    TIME

    CUME_DIST

    NEW

    TIMESTAMP

    CURRENT_CATALOG

    NEXT

    TIMEZONE_HOUR

    CURRENT_DEFAULT_TRANSFORM_GROUP

    NO

    TIMEZONE_MINUTE

    CURRENT_PATH

    NONE

    TRAILING

    CURRENT_ROLE

    NORMALIZE

    TRANSLATE_REGEX

    CURRENT_SCHEMA

    NUMERIC

    TRANSLATION

    CURRENT_TRANSFORM_GROUP_FOR_TYPE

    OBJECT

    TREAT

    CYCLE

    OCCURRENCES_REGEX

    TRUE

    DATA

    OLD

    UESCAPE

    DATE

    ONLY

    UNDER

    DAY

    OPERATION

    UNKNOWN

    DEC

    ORDINALITY

    UNNEST

    DECIMAL

    OUT

    USAGE

    DEFERRABLE

    OVERLAY

    USING

    DEFERRED

    OUTPUT

    VALUE

    DEPTH

    PAD

    VAR_POP

    DEREF

    PARAMETER

    VAR_SAMP

    DESCRIBE

    PARAMETERS

    VARCHAR

    DESCRIPTOR

    PARTIAL

    VARIABLE

    DESTROY

    PARTITION

    WHENEVER

    DESTRUCTOR

    PATH

    WIDTH_BUCKET

    DETERMINISTIC

    POSTFIX

    WITHOUT

    DICTIONARY

    PREFIX

    WINDOW

    DIAGNOSTICS

    PREORDER

    WITHIN

    DISCONNECT

    PREPARE

    WORK

    DOMAIN

    PERCENT_RANK

    WRITE

    DYNAMIC

    PERCENTILE_CONT

    XMLAGG

    EACH

    PERCENTILE_DISC

    XMLATTRIBUTES

    ELEMENT

    POSITION_REGEX

    XMLBINARY

    END-EXEC

    PRESERVE

    XMLCAST

    EQUALS

    PRIOR

    XMLCOMMENT

    EVERY

    PRIVILEGES

    XMLCONCAT

    EXCEPTION

    RANGE

    XMLDOCUMENT

    FALSE

    READS

    XMLELEMENT

    FILTER

    REAL

    XMLEXISTS

    FIRST

    RECURSIVE

    XMLFOREST

    FLOAT

    REF

    XMLITERATE

    FOUND

    REFERENCING

    XMLNAMESPACES

    FREE

    REGR_AVGX

    XMLPARSE

    FULLTEXTTABLE

    REGR_AVGY

    XMLPI

    FUSION

    REGR_COUNT

    XMLQUERY

    GENERAL

    REGR_INTERCEPT

    XMLSERIALIZE

    GET

    REGR_R2

    XMLTABLE

    GLOBAL

    REGR_SLOPE

    XMLTEXT

    GO

    REGR_SXX

    XMLVALIDATE

    GROUPING

    REGR_SXY

    YEAR

    HOLD

    REGR_SYY

    ZONE

    感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!

    您可能感兴趣的文章:
    • 查找oracle数据库表中是否存在系统关键字的方法
    • Access数据库中“所有记录中均未找到搜索关键字”的解决方法
    • 数据库删除完全重复和部分关键字段重复的记录
    • Linux 自动备份oracle数据库详解
    • 利用SQL Server数据库邮件服务实现监控和预警
    • myeclipse中连接mysql数据库示例代码
    • Myeclipse连接mysql数据库心得体会
    • MyEclipse连接MySQL数据库图文教程
    • python爬取NUS-WIDE数据库图片
    • 记一次mariadb数据库无法连接
    上一篇:SQL Server 实现数字辅助表实例代码
    下一篇:SQL Function 自定义函数详解
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    数据库 关键字一览表 数据库,关键字,一览表,