Ispirer SQLWays Database Migration Software

Oracle Reserved Words

There are reserved words in Oracle which cannot be used as identifiers (table or column names etc.) without being delimited with double quotation marks ("). The only exception is that you cannot use the uppercase reserved word ROWID as an identifier, even in double quotation marks.

If an identifier name is a reserved word delimited with double quotation marks then you must use double quotation marks whenever you refer to this object. As the delimited identifiers are case sensitive, you should refer to this object using the same case of the letters as you were using when naming the object.

For example, if you create the table with the name "ELSE", then you should refer to this table like "ELSE" and not like "Else" or "eLSE".

Many Oracle reserved words are valid object or column names in other databases. So tables migrated from other databases to Oracle may contain Oracle reserved words.

For example, LEVEL is a reserved word in Oracle, but it is not a reserved word in IBM DB2 and Microsoft SQL Server. A column can be named LEVEL in IBM DB2 and Microsoft SQL Server, but no column is allowed to have the name LEVEL in Oracle.

When a database is migrated to Oracle, SQLWays automatically resolves Oracle reserved words conflicts. SQLWays checks the table and column names for Oracle reserved words, and encloses them in double quotation marks. The reserved word ROWID is replaced with the delimited identifier "Rowid".

SQLWays supports the following Oracle reserved words:

TABLE 86. Oracle reserved words

ACCESS	ADD	ALL
ALTER	AND	ANY
AS	ASC	AUDIT
BETWEEN	BY	CHAR
CHECK	CLUSTER	COLUMN
COMMENT	COMPRESS	CONNECT
CREATE	CURRENT	DATE
DECIMAL	DEFAULT	DELETE
DESC	DISTINCT	DROP
ELSE	EXCLUSIVE	EXISTS
FILE	FLOAT	FOR
FROM	GRANT	GROUP
HAVING	IDENTIFIED	IMMEDIAE
IN	INCREMENT	INDEX
INITIAL	INSERT	INTEGER
INTERSECT	INTO	IS
LEVEL	LIKE	LOCK
LONG	MAXEXTENTS	MINUS
MISLABEL	MODE	MODIFY
NOAUDIT	NOCOMPRESS	NOT
NOWAIT	NULL	NUMBER
OF	OFFLINE	ON
ONLINE	OPTION	OR
ORDER	PCTFREE	PRIOR
PRIVILEGES	PUBLIC	RAW
RENAME	RESOURCE	REVOKE
ROW	ROWID	ROWNUM
ROWS	SELECT	SESSION
SET	SHARE	SIZE
SMALLINT	START	SUCCESSFUL
SYNONYM	SYSDATE	TABLE
THEN	TO	TRIGGER
UID	UNION	UNIQUE
UPDATE	USER	VALIDATE
VALUES	VARCHAR	VARCHAR2
VIEW	WHENEVER	WHERE
WITH

             

Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.