Keyword (keyword)

Keyword (keyword). A distinction is made between normal (not_reserved_keyword) and reserved (reserved_keyword) keywords.

Structure

Syntax Syntax

<keyword> ::=
  <not_reserved_keyword>
| <reserved_keyword>

End of the code.

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`
`EDITPROC`	`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`

More Information

Identifier (identifier)

Character Set (token)