C Oracle Database Lite Keywords and Reserved Words

This appendix lists Oracle Lite keywords and reserved words.

C.1 Oracle Lite Keywords

Keywords are not reserved words, but have special meanings in certain contexts. They can be used to define table and column names.

Note:

Exercise caution when defining a new method for a Java class as aggregate names (AVG, MAX, MIN, COUNT, SUM) and function names (UPPER, LOWER, and so on) take precedence over user defined method names.

Oracle Lite keywords are listed in Table C-1:

Table C-1 Oracle Database Lite Keywords

Letter	Keywords
A	ADD_MONTHS AFTER ARGS	ASCII AUTOCOMMIT AVG
B	BEFORE BIGINT BINARY	BIT BIT_LENGTH
C	CASCADE CAST CATALOG CEIL CHAR CHAR_LENGTH CHARACTER CHR COMMIT COMMITTED	COMPILE CONCAT CONSTRUCTOR CONVERT COUNT CURDATE CURTIME CURTIMESTAMP CURVAL
D	DATABASE_ID DATABASE_SIZE DATE DAY DAYOFMONTH DAYOFWEEK DAYOFYEAR DEBUG_LITE	DEC DECIMAL DOUBLE DUAL (Do not use as a table name as this is already the name of a dummy table.) DUMP$
E	EXTENT_SIZE EXTRACT
F	FLOOR
G	GREATEST
H	HIDE HOUR
I	IFNULL INITCAP INSTR INSTRB	INT INTERVAL ISOLATION
K	KEY
L	LAST_DAY LCASE LEAST LENGTH LENGTHB	LEVEL LOCATE LOWER LPAD LTRIM
M	MAX MAXVALUE MIN MINUTE	MINVALUE MOD MONTH MONTHS_BETWEEN
N	NEXT_DAY NEXTVAL NOMAXVALUE NOMINVALUE NOW	NUMBER NUMERIC NVL
O	OCTET_LENGTH OJ
P	POSITION PRECISION
Q	QUARTER
R	READ REAL REPEATABLE REPLACE RESTRICT	ROUND ROWID RPAD RTRIM
S	SAVEPOINT SCHEMA SECOND SEQUENCE SERIALIZABLE SMALLINT SOURCE 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 START STDDEV SUBSTR SUBSTRB SUBSTRING SUM
T	TIME TIMESTAMP TIMESTAMPADD TIMESTAMPDIFF TINYINT TO_CHAR	TO_DATE TO_NUMBER TRANSACTION TRANSLATE TRIMBOTH TRUNC
U	UCASE UNCOMMITTED	UPPER
V	VARBINARY VARIANCE	VARYING
W	WEEK WORK
Y	YEAR
Z	ZONE

Note:

You can use the keywords NEXTVAL and CURVAL as column names of a table. However, Oracle Lite treats tablename.NEXTVAL and tablename.CURVAL as referring to a sequence.

C.2 Oracle Lite Reserved Words

Reserved words cannot be used as the name of any database object or part. The Oracle Lite reserved words are listed in Table C-2. Some Oracle Lite reserved words are also Oracle reserved words. Any words followed by an asterisk (*) are only Oracle Lite reserved words (not Oracle):

Table C-2 Oracle Database Lite Reserved Words

Letter	Reserved Words
A	ADD ALL ALTER AND	ANY AS ASC ATTACH*
B	BETWEEN BOTH*	BY
C	CALL* CASE* CAST* CHECK CLASS* COLUMN COMMENT	CONNECT CONSTRAINT* CONSTRAINTS* CREATE CURRENT CURRENT_DATE* CURRENT_TIME* CURRENT_TIMESTAMP*
D	DATABASE DECODE* DEFAULT DELETE	DESC DETACH* DISTINCT DROP
E	EACH* ELSE END*	ESCAPE* EXISTS
F	FLOAT FOR FOREIGN*	FROM FULL*
G	GRANT GROUP
H	HAVING
I	IN INCREMENT INDEX INSERT INTEGER	INTERSECT INTERVAL* INTO IS
J	JOIN* JAVA
L	LEADING* LEFT* LIKE	LOCK LONG
M	MINUS
N	NOT NOWAIT	NULL
O	OF OFF* ON OR	ORDER, OUTER* OPTION
P	PRIMARY* PRIOR	PUBLIC
R	RAW REFERENCES* REVOKE	RIGHT* ROLLBACK* ROW
S	SELECT SESSION SET SOME* SQL_BIGINT* SQL_CHAR* SQL_DATE* SQL_DECIMAL* SQL_DOUBLE* SQL_FLOAT*	SQL_INTEGER* SQL_LONGVARCHAR* SQL_REAL* SQL_SMALLINT* SQL_TIME* SQL_TIMESTAMP* SQL_VARCHAR* START SYNONYM SYSDATE
T	TABLE THEN TIMESTAMPADD* TIMESTAMPDIFF* TIMEZONE_HOUR*	TIMEZONE_MINUTE* TO TRAILING* TRIGGER TRIM*
U	UNION UNIQUE	UPDATE USER
V	VALUES VARCHAR	VARCHAR2 VIEW
W	WHEN* WHERE	WITH