| SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / Data manipulation | |
SQL object names like table and column names cannot be SQL reserved words in ORACLE.
An example of a common word which is part of the ORACLE SQL grammar is 'level'.
Table or column names which are ORACLE reserved words must be renamed.
ORACLE reserved keywords are listed in the ORACLE documentation, or Oracle 8i provides the V$RESERVED_WORDS view to track Oracle reserved words. All BDL application sources must be verified. To check if a given keyword is used in a source, you can use UNIX™ 'grep' or 'awk' tools. Most modifications can be done automatically with UNIX tools like 'sed' or 'awk'.