Explanation
Keywords can be entered in uppercase/lowercase characters. Generally
speaking, keywords should not be used to designate objects.
Normal Keywords (not_reserved_keyword)
ABS
|
ACOS
|
ADD
|
ADDDATE
|
ADDRESS
|
ADDTIME
|
ADD_MONTH
|
AFTER
|
ALPHA
|
ALTERIN
|
ANALYZE
|
AND
|
ANSI
|
APPEND
|
AS
|
ASC
|
ASIN
|
AT
|
ATAN
|
ATAN2
|
AUTHORIZATION
|
AUTO
|
AUTOSAVE
|
AVG
|
|
BAD
|
BEFORE
|
BEGIN
|
BEGINLOAD
|
BEGINPROC
|
BETWEEN
|
BLOCK
|
BLOCKSIZE
|
BOTH
|
BREAK
|
BUFFER
|
BUFFERPOOL
|
BWHIERARCHY
|
BY
|
|
CACHE
|
CACHELIMIT
|
CACHES
|
CALL
|
CANCEL
|
CASCADE
|
CASE
|
CATALOG
|
CATCH
|
CEIL
|
CEILING
|
CHECKPOINT
|
CHR
|
CLEAR
|
CLOSE
|
CLUSTER
|
COALESCE
|
COMMENT
|
COMMIT
|
COMPUTE
|
CONCAT
|
CONFIG
|
CONNECT
|
CONSTRAINTS
|
CONTAINER
|
CONTINUE
|
COS
|
COSH
|
COSTLIMIT
|
COSTWARNING
|
COT
|
COUNT
|
CREATE
|
CREATEIN
|
CURRENT_DATE
|
CURRENT_TIME
|
CURRENT_TIMESTAMP
|
CURRVAL
|
CURSOR
|
CYCLE
|
DAFS
|
DATA
|
DATEDIFF
|
DAY
|
DAYNAME
|
DAYOFMONTH
|
DAYOFWEEK
|
DAYOFYEAR
|
DAYS
|
DB2
|
DBA
|
DBPROC
|
DBPROCEDURE
|
DEBUG
|
DECLARE
|
DECODE
|
DEFAULTCODE
|
DEGREE
|
DEGREES
|
DESC
|
DESCRIBE
|
DETERMINISTIC
|
DEVICE
|
DIAGNOSE
|
DIGITS
|
DIMENSION
|
DISABLE
|
DIV
|
DO
|
DOMAIN
|
DROP
|
DROPIN
|
DSETPASS
|
DUPLICATES
|
DYNAMIC
|
E DITPROC
|
ELSE
|
ENABLE
|
END
|
ENDLOAD
|
ENDPROC
|
ERROR
|
ESCAPE
|
ESTIMATE
|
EUR
|
EXCLUSIVE
|
EXECUTE
|
EXP
|
EXPAND
|
EXPLAIN
|
EXPLICIT
|
EXTENDED
|
EXTERNALLY
|
|
|
FACT
|
FETCH
|
FILE
|
FLOOR
|
FLUSH
|
FORCE
|
FOREIGN
|
FORMAT
|
FREEPAGE
|
FUNCTION
|
FVERSION
|
|
|
|
|
GET
|
GET_OBJECTNAME
|
GET_SCHEMA
|
GRANT
|
GREATEST
|
HEX
|
HEXTORAW
|
HIGH
|
HISTORY
|
HOLD
|
HOUR
|
HOURS
|
|
|
|
IDENTIFIED
|
IDENTIFIER
|
IF
|
IFNULL
|
IMPLICIT
|
IMPORT
|
IN
|
INCREMENT
|
INDEX
|
INDEXNAME
|
INDICATOR
|
INFO
|
INIT
|
INITCAP
|
INITRANS
|
INOUT
|
INPROC
|
INSTANCE
|
INSTR
|
INTTORAW
|
IS
|
ISO
|
ISOLATION
|
ISUPDATECOLUMN
|
|
JAVA
|
JIS
|
|
|
|
LABEL
|
LANGUAGE
|
LAST_DAY
|
LCASE
|
LEAST
|
LEFT
|
LENGTH
|
LEVEL
|
LFILL
|
LIKE
|
LN
|
LOAD
|
LOCAL
|
LOCATE
|
LOCK
|
LOG
|
LOG10
|
LOGFULL
|
LOGWRITER
|
LOW
|
LOWER
|
LPAD
|
LTRIM
|
|
|
MAKEDATE
|
MAKETIME
|
MAPCHAR
|
MAX
|
MAXTRANS
|
MAXVALUE
|
MBCS
|
MEDIANAME
|
MEDIUM
|
MICROSECOND
|
MICROSECONDS
|
MIGRATE
|
MIN
|
MINUS
|
MINUTE
|
MINUTES
|
MINVALUE
|
MOD
|
MODE
|
MODIFY
|
MONITOR
|
MONTH
|
MONTHNAME
|
MONTHS
|
MONTHS_BETWEEN
|
NAME
|
NEW
|
NEW_TIME
|
NEXTVAL
|
NEXT_DAY
|
NLSSORT
|
NLS_DATE_FORMAT
|
NLS_DATE_LANGUAGE
|
NLS_LANGUAGE
|
NLS_SORT
|
NOCACHE
|
NOCYCLE
|
NOLOG
|
NOMAXVALUE
|
NOMINVALUE
|
NONE
|
NOORDER
|
NOREWIND
|
NORMAL
|
NOROUND
|
NOSORT
|
NUM
|
NUMBER
|
NVL
|
|
OBID
|
OFF
|
ONLY
|
OPEN
|
OPTIMISTIC
|
OPTIMIZE
|
OPTION
|
OR
|
ORACLE
|
OUT
|
OUTER
|
OVERWRITE
|
|
|
|
PACKAGE
|
PAGE
|
PAGES
|
PARAM
|
PARAMETER
|
PARSE
|
PARSEID
|
PARTITION
|
PASSWORD
|
PCTFREE
|
PCTUSED
|
PER
|
PERCENT
|
PERMANENT
|
PING
|
PIPE
|
POS
|
POWER
|
PRECISION
|
PREPARE
|
PREPAREDSTATEMENT
|
PRIV
|
PRIVILEGES
|
PROC
|
PROCEDURE
|
PSM
|
PUBLIC
|
|
|
|
QUICK
|
|
|
|
|
RADIANS
|
RANGE
|
RAW
|
RAWTOHEX
|
READ
|
RECURSIVE
|
REFERENCES
|
REGISTER
|
RELATIVE
|
RELEASE
|
REMOTE
|
REMOVE
|
RENAME
|
REPLACE
|
REPLICATION
|
REPOSITORY
|
RESET
|
RESOURCE
|
RESTART
|
RESTORE
|
RESTRICT
|
RESUME
|
RETURN
|
RETURNS
|
REUSE
|
REVOKE
|
RFILL
|
RIGHT
|
ROLE
|
ROLLBACK
|
ROUND
|
ROW
|
ROWNUM
|
ROWS
|
RPAD
|
RTRIM
|
|
|
|
|
SAME
|
SAMPLE
|
SAPR3
|
SAVE
|
SAVEPOINT
|
SCHEMA
|
SECOND
|
SECONDS
|
SELECTIVITY
|
SEQUENCE
|
SERVERDB
|
SESSION
|
SHARE
|
SHARED
|
SHUTDOWN
|
SIGN
|
SIN
|
SINH
|
SNAPSHOT
|
SOUNDEX
|
SOUNDS
|
SPACE
|
SQLID
|
SQLMODE
|
SQRT
|
STANDARD
|
STANDBY
|
START
|
STARTPOS
|
STAT
|
STATE
|
STATIC
|
STDDEV
|
STOP
|
STORAGE
|
SUBDATE
|
SUBPAGES
|
SUBSTR
|
SUBSTRING
|
SUBTIME
|
SUBTRANS
|
SUM
|
SUSPEND
|
SWITCH
|
SYNCHRONIZE
|
SYNONYM
|
SYSDATE
|
SYSTEM
|
|
|
TABLESPACE
|
TAKEOVER
|
TAN
|
TANH
|
TAPE
|
TEMP
|
THEN
|
TIMEDIFF
|
TIMEOUT
|
TOIDENTIFIER
|
TO_CHAR
|
TO_DATE
|
TO_NUMBER
|
TRACE
|
TRANSLATE
|
TRIGGER
|
TRIM
|
TRUNC
|
TRUNCATE
|
TRY
|
TYPE
|
|
|
|
|
UCASE
|
UNIQUE
|
UNKNOWN
|
UNLOAD
|
UNLOCK
|
UNTIL
|
UNUSED
|
UPPER
|
UPSERT
|
USA
|
USAGE
|
USERID
|
|
|
|
VALIDPROC
|
VALUE
|
VARCHAR2
|
VARIANCE
|
VERIFY
|
VERSION
|
VIEW
|
VOLUME
|
VSIZE
|
VTRACE
|
WAIT
|
WEEK
|
WEEKOFYEAR
|
WHENEVER
|
WHILE
|
WORK
|
WRITE
|
WRITER
|
|
|
YEAR
|
YEARS
|
|
|
|
Reserved Keywords (reserved_keyword)
You must not use reserved keywords as simple identifiers. However,
you can use reserved keywords as identifiers in the form of special identifiers.
ABSOLUTE
|
ALL
|
ALTER
|
ANY
|
ASCII
|
BINARY
|
BIT
|
BLOB
|
BOOLEAN
|
BYTE
|
CHAR
|
CHARACTER
|
CHECK
|
CLOB
|
COLUMN
|
CONSTRAINT
|
CROSS
|
CURDATE
|
CURRENT
|
CURRENT_SCHEMA
|
CURTIME
|
|
|
|
|
DATABASE
|
DATE
|
DEC
|
DECIMAL
|
DEFAULT
|
DELETE
|
DISTINCT
|
DOUBLE
|
|
|
EXCEPT
|
EXISTS
|
|
|
|
FALSE
|
FIRST
|
FIXED
|
FLOAT
|
FOR
|
FROM
|
FULL
|
|
|
|
GRAPHIC
|
GROUP
|
|
|
|
HAVING
|
|
|
|
|
IGNORE
|
INNER
|
INSERT
|
INT
|
INTEGER
|
INTERNAL
|
INTERSECT
|
INTO
|
|
|
JOIN
|
|
|
|
|
KEY
|
|
|
|
|
LAST
|
LIMIT
|
LIST
|
LONG
|
LONGFILE
|
NATURAL
|
NCHAR
|
NCLOB
|
NEXT
|
NO
|
NOT
|
NOW
|
NOWAIT
|
NULL
|
NUMERIC
|
NVARCHAR
|
|
|
|
|
OBJECT
|
OF
|
ON
|
ORDER
|
|
PACKED
|
PI
|
PREV
|
PRIMARY
|
|
REAL
|
REJECT
|
ROWID
|
ROWNO
|
|
SELECT
|
SELUPD
|
SERIAL
|
SET
|
SHOW
|
SMALLINT
|
SOME
|
STAMP
|
STATISTICS
|
SYSDBA
|
TABLE
|
TIME
|
TIMESTAMP
|
TIMEZONE
|
TO
|
TOP
|
TRANSACTION
|
TRUE
|
|
|
UID
|
UNICODE
|
UNION
|
UPDATE
|
USER
|
USERGROUP
|
USING
|
UTCDATE
|
UTCDIFF
|
|
VALUES
|
VARCHAR
|
VARGRAPHIC
|
|
|
WHEN
|
WHERE
|
WITH
|
|
|
ZONED
|
|
|
|
|
Keyword (keyword)
Syntax