Reserved Keywords

Reserved words are keywords you can use as identifiers in SQL statements if you delimit them with double quotation marks. If you use keywords without delimiting them, the statement generates one of the following errors:

error(-20003): Syntax error
error(-20049): Keyword used for a name

The following table lists reserved words. The list is alphabetic and reads left to right.

• A
• ABS
• ACOS
• ADD
• ADD_MONTHS
• AFTER
• ALL
• ALTER
• AN
• AND
• ANY
• ARRAY
• AS
• ASC
• ASCII
• ASIN
• ATAN
• ATAN2
• AVG
• BEFORE
• BEGIN
• BETWEEN
• BIGINT
• BINARY
• BIND
• BINDING
• BIT
• BY
• CALL
• CASCADE
• CASE
• CAST
• CEILING
• CHAR
• CHAR_LENGTH
• CHARACTER
• CHARACTER_LENGTH
• CHARTOROWID
• CHECK
• CHR
• CLEANUP
• CLOSE
• CLUSTERED
• COALESCE
• COLGROUP
• COLLATE
• COLUMN
• COMMIT
• COMPLEX
• COMPRESS
• CONCAT
• CONNECT
• CONSTRAINT
• CONTAINS
• CONTINUE
• CONVERT
• COS
• COUNT
• CREATE
• CROSS
• CURDATE
• CURRENT
• CURSOR
• CURTIME
• CVAR
• DATABASE
• DATAPAGES
• DATE
• DAYNAME
• DAYOFMONTH
• DAYOFWEEK
• DAYOFYEAR
• DB_NAME
• DBA
• DEC
• DECIMAL
• DECLARATION
• DECLARE
• DECODE
• DEFAULT
• DEFINITION
• DEGREES
• DELETE
• DESC
• DESCRIBE
• DESCRIPTOR
• DHTYPE
• DIFFERENCE
• DISTINCT
• DOUBLE
• DROP
• EACH
• ELSE
• END
• END
• ESCAPE
• EXCLUSIVE
• EXEC
• EXECUTE
• EXISTS
• EXIT
• EXP
• EXPLICIT
• FETCH
• FIELD
• FILE
• FLOAT
• FLOOR
• FOR
• FOREIGN
• FOUND
• FROM
• FULL
• GO
• GOTO
• GRANT
• GREATEST
• GROUP
• HASH
• HAVING
• HOUR
• IDENTIFIED
• IFNULL
• IMMEDIATE
• IN
• INDEX
• INDEXPAGES
• INDICATOR
• INITCAP
• INNER
• INOUT
• INPUT
• INSERT
• INSTR
• INT
• INTEGER
• INTERFACE
• INTERSECT
• INTO
• IS
• JOIN
• KEY
• LAST_DAY
• LCASE
• LEAST
• LEFT
• LEFT
• LENGTH
• LIKE
• LINK
• LIST
• LOCATE
• LOCK
• LOG
• LOG10
• LONG
• LONG
• LOWER
• LPAD
• LTRIM
• LVARBINARY
• LVARCHAR
• MAIN
• MAX
• METADATA_ONLY
• MIN
• MINUS
• MINUTE
• MOD
• MODE
• MODIFY
• MONEY
• MONTH
• MONTHNAME
• MONTHS_BETWEEN
• NATIONAL
• NATURAL
• NCHAR
• NEWROW
• NEXT_DAY
• NOCOMPRESS
• NOT
• NOW
• NOWAIT
• NULL
• NULLIF
• NULLVALUE
• NUMBER
• NUMERIC
• NVL
• OBJECT_ID
• ODBC_CONVERT
• ODBCINFO
• OF
• OLDROW
• ON
• OPEN
• OPTION
• OR
• ORDER
• OUT
• OUTER
• OUTPUT
• PCTFREE
• PI
• POWER
• PRECISION
• PREFIX
• PREPARE
• PRIMARY
• PRIVILEGES
• PROCEDURE
• PUBLIC
• QUARTER
• RADIANS
• RAND
• RANGE
• RAW
• REAL
• RECORD
• REFERENCES
• REFERENCING
• RENAME
• REPEAT
• REPLACE
• RESOURCE
• RESTRICT
• RESULT
• RETURN
• REVOKE
• RIGHT
• RIGHT
• ROLLBACK
• ROW
• ROWID
• ROWIDTOCHAR
• ROWNUM
• RPAD
• RTRIM
• SEARCHED_CASE
• SECOND
• SECTION
• SELECT
• SERVICE
• SET
• SHARE
• SHORT
• SIGN
• SIMPLE_CASE
• SIN
• SIZE
• SMALLINT
• SOME
• SOUNDEX
• SPACE
• SQL
• SQL_BIGINT
• SQL_BINARY
• SQL_BIT
• SQL_CHAR
• SQL_DATE
• SQL_DECIMAL
• SQL_DOUBLE
• SQL_FLOAT
• SQL_INTEGER
• SQL_LONGVARBINARY
• SQL_LONGVARCHAR
• SQL_NUMERIC
• SQL_REAL
• SQL_SMALLINT
• SQL_TIME
• SQL_TIMESTAMP
• SQL_TINYINT
• SQL_TSI_DAY
• SQL_TSI_FRAC_SECOND
• SQL_TSI_HOUR
• SQL_TSI_MINUTE
• SQL_TSI_MONTH
• SQL_TSI_QUARTER
• SQL_TSI_SECOND
• SQL_TSI_WEEK
• SQL_TSI_YEAR
• SQL_VARBINARY
• SQL_VARCHAR
• SQLERROR
• SQLWARNING
• SQRT
• START
• STATEMENT
• STATISTICS
• STOP
• STORAGE_ATTRIBUTES
• STORAGE_MANAGER
• STORE_IN_DHARMA
• SUBSTR
• SUBSTRING
• SUFFIX
• SUM
• SUSER_NAME
• SYNONYM
• SYSDATE
• SYSTIME
• SYSTIMESTAMP
• TABLE
• TAN
• THEN
• TIME
• TIMEOUT
• TIMESTAMP
• TIMESTAMPADD
• TIMESTAMPDIFF
• TINYINT
• TO
• TO_CHAR
• TO_DATE
• TO_NUMBER
• TO_TIME
• TO_TIMESTAMP
• TPE
• TRANSACTION
• TRANSLATE
• TRIGGER
• TYPE
• UCASE
• UID
• UNION
• UNIQUE
• UNSIGNED
• UPDATE
• UPPER
• USER
• USER_ID
• USER_NAME
• USING
• UUID
• VALUES
• VARBINARY
• VARCHAR
• VARIABLES
• VARYING
• VERSION
• VIEW
• WEEK
• WHEN
• WHENEVER
• WHERE
• WITH
• WORK
• YEAR