Skip Headers
Oracle® Database Lite SQL Reference
10g (10.3.0)

Part Number B28925-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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