如何查看oracle数据库的所有的关键字

管理员账户登录后,执行以下命令:  select * from v$reserved_words

  

附上参考:

NOMONITORING
RECORDS_PER_BLOCK
CASCADE
DYNAMIC_SAMPLING
COLUMN_STATS
GROUPS
NO_PX_JOIN_FILTER
CONSTRAINT
NO_STATS_GSETS
SWAP_JOIN_INPUTS
NOORDER
TRIGGERS
SHARE
DEMAND
TIMEOUT
LOB
GBY_CONC_ROLLUP
ROWDEPENDENCIES
+
NOSTRICT
PRIVILEGE
SEMIJOIN
RAW
USE_NL_WITH_INDEX
INFORMATIONAL
DENSE_RANK
NO_QUERY_TRANSFORMATION
POINT
TRACING
NO_XML_QUERY_REWRITE
NOPARALLEL_INDEX
LINK
REF
NO_ELIMINATE_OUTER_JOIN
PIV_SSF
INTERPRETED
READS
DELAY
REAL
BFILE
PRIVATE
MAXLOGMEMBERS
USE_SEMI
COST
PREPARE
EVALNAME
NO_CARTESIAN
TABNO
TRACE
PLAN
HINTSET_END
CONTAINER
DROP
ADMIN
COLUMN
JOIN
SYSTEM
NEW
TZ_OFFSET
NLS_LENGTH_SEMANTICS
DICTIONARY
SCN_ASCENDING
FIC_CIV
BETWEEN
NOOVERRIDE
INDICATOR
BINARY_FLOAT_NAN
ROWID
SESSION_CACHED_CURSORS
OBJNO
SQL_TRACE
BLOB
RELATIONAL
BIGFILE
AVAILABILITY
GUARD
GROUP_BY
ADVISE
MERGE
QUOTA
CFILE
MEMBER
WORK
THAN
SALT
DUMP
FROM
REVERSE
BOTH
GUARANTEED
CACHE_CB
FULL
SECURITY
SCALE
SYS_DL_CURSOR
DECLARE
COARSE
TYPE
ADD
DEREF_NO_REWRITE
AUTO
ESTIMATE
POWER
DESC
USE_STORED_OUTLINES
SID
VARRAY
LESS
VALUE
OPTION
XMLFOREST
MAXLOGHISTORY
STORE
REDUNDANCY
DEQUEUE
DBA
MATCHED
PRESENT
CPU_PER_CALL
CONTEXT
UPD_JOININDEX
NESTED_TABLE_SET_REFS
<
EXPAND_GSET_TO_UNION
^
INDEX_SS_ASC
EXTRACT
ORDERED_PREDICATES
ALIAS
NO_USE_HASH
PRIOR
X_DYN_PRUNE
COMPOSITE_LIMIT
OBJNO_REUSE
WAIT
UNBOUNDED
DISABLE
CURRENT_DATE
INITIAL
MINIMUM
INTERMEDIATE
PARTITION_LIST
BYTE
MOUNT
PREBUILT
LONG
SOURCE
THEN
MODEL_PBY
BITMAP_TREE
LOGFILE
ROLES
DEGREE
DBMS_STATS
TABLESPACE
DEFAULT
COMMENT
PASSWORD_VERIFY_FUNCTION
ESCAPE
COLUMNS
P
CHOOSE
SMALLFILE
LEVEL
OLD_PUSH_PRED
MOVEMENT
DEFINER
SERVERERROR
NESTED_TABLE_FAST_INSERT
ALTER
STREAMS
IS
NL_SJ
ELIMINATE_OUTER_JOIN
ENTERPRISE
,
DISASSOCIATE
GROUPING
VECTOR_READ_TRACE
FREELIST
CHILD
M
NO_PRUNE_GSETS
INTO
REJECT
NORESETLOGS
ENABLE
CHUNK
RESET
OID
RETENTION
MAXTRANS
NUMERIC
FBTSCAN
NONE
PARAMETERS
ONLINE
OUT_OF_LINE
MINUS
SPACE
HINTSET_BEGIN
INTEGER
PASSWORD_GRACE_TIME
EXPORT
FINAL
YEAR
RBA
ERRORS
CLASS
USE_NL
DOMAIN_INDEX_SORT
BINARY_DOUBLE
DEFINED
EVALUATION
PURGE
HOUR
LENGTH
SESSION
PRECEDING
OWN
SUBMULTISET
INDEX_ROWS
SCHEDULER
AUTHENTICATION
NUMBER
OIDINDEX
OPAQUE
XID
USING
TIME
GRANT
INFINITE
ORA_ROWSCN
TRUSTED
CACHE_INSTANCES
MATERIALIZED
INDEX_COMBINE
OPAQUE_XCANONICAL
INLINE_XMLTYPE_NT
RETURNING
QUERY
OPT_ESTIMATE
/
CLOB
NO_EXPAND
DETACHED
PASSWORD_LOCK_TIME
VECTOR_READ
DATAFILE
IDENTIFIED
REPLACE
NLS_CHARACTERSET
NO_ELIMINATE_JOIN
BROADCAST
CIV_GB
HASH
QB_NAME
AFTER
SYSDBA
ACCOUNT
SEVERE
IF
PRECOMPUTE_SUBQUERY
FUNCTION
INDEXTYPES
FLOB
CONNECT_BY_ROOT
NLS_SPECIAL_CHARS
SKIP
IGNORE_OPTIM_EMBEDDED_HINTS
INDEX_SS
NOGUARANTEE
LOCALTIMESTAMP
DBA_RECYCLEBIN
FILE
THROUGH
MULTISET
OFF
MANAGE
DRIVING_SITE
FAILED
SCAN_INSTANCES
COMPLETE
HIGH
TRANSITIONAL
CONTINUE
NO_SEMIJOIN
DAY
NOPARALLEL
ALL
XMLATTRIBUTES
MOVE
NAME
DYNAMIC
NATIONAL
REQUIRED
SKIP_EXT_OPTIMIZER
NOREPAIR
!
REBUILD
JOB
SEED
POLICY
TO
TOPLEVEL
BITMAP
DATAFILES
HASH_AJ
INITRANS
ORDER
BLOCKSIZE
ON
FAST
MINIMIZE
SESSIONTZNAME
SESSIONS_PER_USER
SYS_OP_BITVEC
NO_ELIMINATE_OBY
UBA
POST_TRANSACTION
BODY
DATA
SUBPARTITION_REL
SETS
PRIVATE_SGA
BINARY_FLOAT
ENFORCED
TABLE_STATS
FLAGGER
ROW
TEMP_TABLE
ARCHIVE
NO_PUSH_SUBQ
RECYCLE
DATAOBJNO
QUEUE_ROWP
SQL
CONTENT
MODIFY
EMPTY
SAVE_AS_INTERVALS
BITMAPS
OPTIMIZER_FEATURES_ENABLE
FUNCTIONS
AUTOMATIC
SECOND
NO_FILTERING
NAMED
FLOAT
PRIVILEGES
SD_SHOW
SUSPEND
LIKEC
NO_BUFFER
WITHIN
PQ_NOMAP
NLS_LANG
ADVISOR
FRESH
LATERAL
NO_BASETABLE_MULTIMV_REWRITE
DISCONNECT
PASSWORD
SOME
DATE
CORRUPTION
HASHKEYS
EXCLUDING
INDEX_RRS
DISK
BITS
APPLY
USE
<<
STAR
CURSOR_SPECIFIC_SEGMENT
SB4
DISTRIBUTED
HEAP
MINEXTENTS
DML
ATTRIBUTES
NORELY
KEYSIZE
LEADING
XMLCOLATTVAL
UNPACKED
FAILED_LOGIN_ATTEMPTS
CONVERT
SHARED_POOL
USE_ANTI
BYPASS_RECURSIVE_CHECK
MAXIMIZE
ABORT
INDEX_FILTER
UNDO
LEFT
CACHE
CANCEL
HAVING
ROLLING
ITERATION_NUMBER
COALESCE
NO_SQL_TUNE
CLUSTER
PROTECTED
PARTITION_HASH
ERROR
NO_MULTIMV_REWRITE
UB2
NOWAIT
SINGLE
SYS_PARALLEL_TXN
INDEX_ASC
THREAD
PARTITION
DISMOUNT
HIERARCHY
STRIP
NLS_DATE_FORMAT
MAXEXTENTS
STORAGE
RESOURCE
COMMITTED
RECYCLEBIN
ANY
TIMESTAMP
PRECISION
CACHE_TEMP_TABLE
ENCRYPTION
LOCALTIME
REWRITE_OR_ERROR
PX_JOIN_FILTER
:
CHAR_CS
EXCEPTIONS
EXPIRE
EACH
AUDIT
RULE
LDAP_REG_SYNC_INTERVAL
NOMINVALUE
G
LIBRARY
COMPILE
MAXVALUE
NAN
TABLE
NOSEGMENT
CURRENT
@
NOLOGGING
NOROWDEPENDENCIES
PATH
NOFORCE
FINISH
FIC_PIV
MAX
SYSAUX
DIMENSION
ORGANIZATION
NOSWITCH
MERGE_CONST_ON
NO
VERSION
KILL
OFFLINE
TRANSACTION
FACT
BECOME
UNBOUND
ROLE
USER
TIV_SSF
OLD
TEMPFILE
EXCEPT
EXPLOSION
REFRESH
MIRROR
REF_CASCADE_CURSOR
OPCODE
OVERFLOW
BULK
CURSOR_SHARING_EXACT
PUSH_SUBQ
CARDINALITY
ALWAYS
LIKE4
TYPES
NOTHING
TIMEZONE_HOUR
UNQUIESCE
RESIZE
=
COLLECT
INSTANCE
SETTINGS
SYSTIMESTAMP
DOMAIN_INDEX_NO_SORT
NLS_NCHAR_CONV_EXCP
BEGIN
LIMIT
SYS_OP_EXTRACT
LIKE2
CROSS
STANDALONE
INDEX
LAST
FOR
NAV
RESTRICT_ALL_REF_CONS
TIMEZONE_REGION
TRUNCATE
UNIFORM
UPDATE
SCAN
RIGHT
WHERE
WITHOUT
CPU_PER_SESSION
PROGRAM
SEG_FILE
CHECK
NOCYCLE
PASSWORD_LIFE_TIME
DML_UPDATE
ALLOW
SKIP_UNQ_UNUSABLE_IDX
NO_MERGE
SMALLINT
CLOSE_CACHED_OPEN_CURSORS
NESTED_TABLE_GET_REFS
SPECIFICATION
WITH
DELETE
BY
CONSISTENT
USE_CONCAT
SYS_OP_NTCIMG$
ASC
.
PQ_MAP
SHUTDOWN
DEFERRABLE
FOLLOWING
NOTIFICATION
SPLIT
UNPROTECTED
WALLET
NOCACHE
INDEX_SKIP_SCAN
LOGICAL
CURRENT_TIMESTAMP
MODEL_MIN_ANALYSIS
KEY
REVOKE
XMLROOT
UNLOCK
NLS_SORT
RAPIDLY
USE_MERGE
QUEUE_CURR
STRICT
END
MV_MERGE
NO_ORDER_ROLLUPS
WRITE
UNLIMITED
SWITCH
CHANGE
DATE_MODE
PLSQL_OPTIMIZE_LEVEL
NO_REWRITE
ANCILLARY
CLUSTERING_FACTOR
BLOCK_RANGE
SEQUENTIAL
GLOBALLY
XMLTYPE
INTERVAL
SEQUENCED
SWITCHOVER
AT
NOMAXVALUE
SYS_FBT_INSDEL
EXTENT
LIKE
KERBEROS
TIMEZONE_OFFSET
INDEX_SS_DESC
RECOVERY
NLS_TERRITORY
SIZE
FAILGROUP
ELEMENT
INSTANCES
SCOPE
IDGENERATORS
STOP
PRESERVE_OID
NO_PARALLEL
SUBPARTITIONS
UPDATABLE
INDEX_JOIN
BEGIN_OUTLINE_DATA
NETWORK
LOCAL
UNUSED
RENAME
NOAUDIT
PHYSICAL
WRAPPED
RETURN
FREEPOOLS
PCTINCREASE
TUNING
GATHER_PLAN_STATISTICS
CREATE_STORED_OUTLINES
SD_INHIBIT
SEGMENT
DISABLE_RPKE
PLSQL_CCFLAGS
PATHS
QUEUE
ENTRY
LDAP_REGISTRATION_ENABLED
DISKS
OBJECT
INCREMENTAL
REGEXP_LIKE
OVERFLOW_NOMOVE
SUBQUERIES
NO_PARALLEL_INDEX
ERROR_ON_OVERLAP_TIME
INITIALIZED
STATISTICS
ENCRYPT
AUTOALLOCATE
TEMPLATE
LDAP_REGISTRATION
NO_UNNEST
NO_PARTIAL_COMMIT
DYNAMIC_SAMPLING_EST_CDN
NLS_COMP
NOCOMPRESS
RULES
TEMPORARY
MAIN
REFERENCING
ENQUEUE
SEG_BLOCK
UNRECOVERABLE
NO_MONITORING
NO_ACCESS
LOCATION
RESOLVER
TIMEZONE_MINUTE
DECREMENT
NO_INDEX
UNNEST
GUARANTEE
BEHALF
NO_QKN_BUFF
TEST
PERMANENT
REGISTER
CONFORMING
&
PARENT
NLS_DATE_LANGUAGE
USE_HASH
OPERATOR
NO_PULL_PRED
STANDBY
OVER
FORCE
SERIALIZABLE
MIGRATE
ITERATE
NULL
INLINE
IGNORE_WHERE_CLAUSE
CPU_COSTING
DEC
TRAILING
LOCAL_INDEXES
OVERLAPS
EXTENDS
NOAPPEND
METHOD
REWRITE
TX
COLUMN_VALUE
DATABASE
EXCHANGE
NO_TEMP_TABLE
UPSERT
YES
REBALANCE
CONSTRAINTS
GROUP
SPFILE
VALUES
EXTERNALLY
TRACKING
RESOLVE
PFILE
MAXDATAFILES
GLOBAL
AUTHENTICATED
NESTED_TABLE_ID
INDEXES
XMLNAMESPACES
NO_REF_CASCADE
SYSDATE
OR_EXPAND
ASSOCIATE
MODEL_COMPILE_SUBQUERY
INITIALLY
PARTIALLY
XMLSCHEMA
SEMIJOIN_DRIVER
PIV_GB
HEADER
RESTORE_AS_INTERVALS
MANAGED
AS
BLOCK
SINGLETASK
DETERMINES
PCTVERSION
EXPLAIN
AND_EQUAL
CLONE
NO_USE_HASH_AGGREGATION
BUFFER_CACHE
DIRECTORY
OUTER
EXTERNAL
FOREIGN
IN
IDENTIFIER
PULL_PRED
INDEXED
LOGICAL_READS_PER_CALL
STARTUP
FREELISTS
UPD_INDEXES
MATERIALIZE
LOGON
SCHEMA
SQLLDR
VIEW
SD_ALL
IN_MEMORY_METADATA
STRUCTURE
NO_MODEL_PUSH_REF
RECOVERABLE
REFERENCED
NO_SET_TO_JOIN
STAR_TRANSFORMATION
CONNECT_BY_ISCYCLE
ROWNUM
SNAPSHOT
EXCLUSIVE
CURRENT_TIME
KEEP
PASSWORD_REUSE_MAX
WHENEVER
INTERNAL_USE
IMMEDIATE
T
PQ_DISTRIBUTE
NOCPU_COSTING
COMMIT
HWM_BROKERED
FIRST_ROWS
RESTRICT
MODEL_NO_ANALYSIS
U
NO_PUSH_PRED
MODEL_PUSH_REF
COMPRESS
NOREVERSE
NO_INDEX_FFS
GENERATED
NATIVE
LIKE_EXPAND
RELY
PACKAGES
READ
IGNORE
DBTIMEZONE
DISKGROUP
FLUSH
BYPASS_UJVC
RESETLOGS
SYS_OP_NOEXPAND
-
PROTECTION
BEFORE
INSTANTIABLE
XMLELEMENT
SUBPARTITION
XMLPARSE
FALSE
ADMINISTER
SELECTIVITY
ROLLUP
PROCEDURE
PCTTHRESHOLD
NEXT
CONTENTS
REKEY
QUIESCE
PX_GRANULE
LOGOFF
SYNONYM
BINDING
CURRENT_USER
THE
XMLPI
PASSWORD_REUSE_TIME
XMLQUERY
SELECT
PARTITIONS
MINVALUE
[
MODEL_DYNAMIC_SUBQUERY
LOCATOR
USERS
NO_STAR_TRANSFORMATION
NOREWRITE
TABLESPACE_NO
ADMINISTRATOR
FILTER
INDEX_FFS
REDUCED
INSERT
KEYS
LOCKED
BUFFER
VALIDATION
FLASHBACK
END_OUTLINE_DATA
TO_CHAR
MASTER
SYS_RID_ORDER
NOSORT
DOUBLE
MINUS_NULL
EXISTS
NVARCHAR2
BOUND
RBO_OUTLINE
ID
NOT
ACTIVATE
ACCESS
MAXSIZE
DECRYPT
UID
ISOLATION
MLSLABEL
UNTIL
AUTOEXTEND
TRIGGER
ELIMINATE_JOIN
RANDOM
SEQUENCE
EXEMPT
PCTUSED
USAGE
ONLY
REUSE
MANUAL
DOCUMENT
CONNECT_BY_ISLEAF
CONSIDER
PROJECT
ENFORCE
REMOTE_MAPPED
LIST
BINARY_DOUBLE_INFINITY
ROW_LENGTH
NULLS
SHARED
WELLFORMED
INCLUDING
APPEND
FORCE_XML_QUERY_REWRITE
ISOLATION_LEVEL
ACCESSED
NLS_ISO_CURRENCY
ELSE
SUCCESSFUL
CURRENT_SCHEMA
INT
ROWS
DANGLING
TRUE
XMLTABLE
ZONE
NLS_NUMERIC_CHARACTERS
|
BACKUP
DEBUG
UPDATED
RESTRICTED
NO_EXPAND_GSET_TO_UNION
STATEMENT_ID
GLOBAL_NAME
AUTHORIZATION
NO_USE_MERGE
OPAQUE_TRANSFORM
ARRAY
MEASURES
VALIDATE
CREATE
MODEL
CASE
CONNECT_TIME
OPTIMIZER_GOAL
SUPPLEMENTAL
>
INTERSECT
]
PCTFREE
OPEN
ANALYZE
RECOVER
DB_ROLE_CHANGE
BLOCKS
MAXINSTANCES
DDL
NOVALIDATE
PRESERVE
CUBE
OPT_PARAM
DISTINCT
CLEAR
ANTIJOIN
CHECKPOINT
IDLE_TIME
SYSOPER
CONNECT
ORDINALITY
SCALE_ROWS
ARCHIVELOG
CERTIFICATE
NORMAL
USE_TTT_FOR_GSETS
TABLES
SET
UPGRADE
K
MERGE_SJ
NOARCHIVELOG
CONTROLFILE
IDENTITY
PERFORMANCE
INSTANTLY
MAPPING
MODE
SHRINK
VARYING
LOGICAL_READS_PER_SESSION
USE_HASH_AGGREGATION
DEFERRED
REPAIR
NO_SWAP_JOIN_INPUTS
GLOBAL_TOPIC_ENABLED
ELIMINATE_OBY
SUBSTITUTABLE
INVALIDATE
NLS_CALENDAR
LAYER
BATCH
KEY_LENGTH
INCREMENT
OF
BUILD
ORDERED
MONTH
NCLOB
EXPR_CORR_CHECK
CLOSE
MEMORY
UROWID
EVENTS
ALL_ROWS
SYS_OP_ENFORCE_NOT_NULL$
CALL
MAXARCHLOGS
COMPUTE
USE_WEAK_NAME_RESL
NOMINIMIZE
WHEN
SPREADSHEET
NL_AJ
*
BUFFER_POOL
MERGE_AJ
A
SIBLINGS
UNIQUE
VARCHAR2
SKIP_UNUSABLE_INDEXES
)
USER_DEFINED
LOG
IMPORT
NESTED_TABLE_SET_SETID
LEVELS
PERCENT
PUSH_PRED
VARCHAR
REFERENCE
CURSOR
RESUME
NO_CPU_COSTING
SIMPLE
(
TIME_ZONE
LOCK
WHITESPACE
NLS_CURRENCY
OR
PLSQL_WARNINGS
PLSQL_DEBUG
EXECUTE
CATEGORY
AUTHID
ATTRIBUTE
FIRST
CHAR
USER_RECYCLEBIN
DEALLOCATE
DECIMAL
TREAT
NEVER
CYCLE
HASH_SJ
UNDROP
MODEL_DONTVERIFY_UNIQUENESS
LOGGING
INDEX_DESC
PASSING
BINARY_FLOAT_INFINITY
SORT
UNION
NOMAPPING
TIMEZONE_ABBR
NODELAY
QUERY_BLOCK
PARTITION_RANGE
SCN
ALLOCATE
SUMMARY
INDEX_STATS
DISTINGUISHED
INTERNAL_CONVERT
NO_USE_NL
NCHAR_CS
SYS_OP_CAST
DOWNGRADE
PUBLIC
NO_INDEX_SS
AND
NESTED
PLSQL_CODE_TYPE
REFERENCES
E
PARITY
MAXLOGFILES
NO_FACT
PACKAGE
XMLSERIALIZE
NEEDED
JAVA
USE_PRIVATE_OUTLINES
DEREF
OUTLINE
SET_TO_JOIN
UNUSABLE
VERSIONS
NCHAR
EXTENTS
SESSIONTIMEZONE
INSTEAD
NATURAL
MONITORING
SAVEPOINT
STATIC
INDEX_SCAN
RESUMABLE
RANGE
RESTORE
MANAGEMENT
COMPATIBILITY
START
CHAINED
ROLLBACK
PRIMARY
UNDER
PARALLEL
TIV_GB
COMPACT
OPTIMAL
CUBE_GB
INCLUDE_VERSION
PARALLEL_INDEX
FINE
BINARY_DOUBLE_NAN
INDEXTYPE
CHARACTER
OUTLINE_LEAF
MIN
INNER
MINUTE
NLS_LANGUAGE
STRING
CAST
UNARCHIVED
PROFILE
SAMPLE

原文地址:https://www.cnblogs.com/rickzhai/p/3427196.html