## SQLWays - Oracle Reserved Words

SQLWays supports the following Oracle reserved words:

ACCESS | ADD | ALL | ALTER | ADD | ANY | ASC | AUDIT
BETWEEN | CHECK | COMMENT | CURRENT | DATE | DEFAULT | DELETE | DESC
DISTINCT | DROP | EXCLUSIVE | FILE | GROUP | INCREMENT | INDEX | INITIAL
INSERT | INTEGER | LEVEL | LOCK | MINUS | MODE | KEY | ORDER
PRIOR | PUBLIC | RESOURCE | REVOKE | ROW | SESSION | SIZE | START
TABLE | UNION | UNIQUE | UPDATE | USER | VALUES | VIEW | WHERE

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.

In Oracle, a name can be enclosed in double quotation marks. Such names can contain any combination of characters, including spaces and reserved words. Then you must use double quotation marks whenever you refer to the object.

SQLWays checks the table and column names for reserved words, and encloses them in double quotation marks.

[Main] [Table of Contents]
Copyright © 1999-2003 Ispirer Systems. All Rights Reserved.
SQLWays™ www.ispirer.com.