October 2004
Intermediate to advanced
896 pages
17h 29m
English
The words listed in this appendix are reserved by PL/SQL. Reserved words have special syntactic meaning in the language and thus can't be used as identifiers (for variable names, procedure names, and so on). Some of these words are reserved by SQL as well and thus can't be used to name database objects such as tables, sequences, and views.
The following table lists the reserved words for PL/SQL, up to and including Oracle10gR1. The reserved word list was increased for 9iR1 and is the same for 9iR2 and 10gR1. In the table, words not reserved in 8iR1 are in bold, while those reserved by SQL have an asterisk (*). You should avoid using any of these words to minimize potential conflicts.
You ...
Read now
Unlock full access