Appendix APL/SQL ReservedWords

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.

Table of Reserved Words

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 ...

Get Oracle Database 10g PL/SQL Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.