This appendix lists Oracle Lite keywords and reserved words.
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 A-1:
Table A-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. |
Reserved words cannot be used as the name of any database object or part. The Oracle Lite reserved words are listed in Table A-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 A-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 |