Oracle® Database Lite SQL Reference Release 10.3 Part Number E12092-02 |
|
|
View PDF |
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 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.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 |