PL/SQL identifiers |
examples of legal identifiersThe following are all valid and legal identifiers: a p_employeeID a1 employee# The following are no valid identifiers; they are considered illegal and will raise an error if used in PL/SQL: a-d _name_ first name 1_counter Reserved wordsReserved words are words or phrases that have special meaning to PL/SQL. Thus, such words and phrases can not be used to define your own identifiers. If you try to, the database will raise errors. Words like IF, FOR, BEGIN, AND, END and many others are part of what is known as reserved words. |
RELATED ARTICLES:
Legal Business Forms
Now you are ready to start a business, you have fully or partially secured your starting capital. You have also done your market research and concluded that your business idea is viable. Now what? Now you have to register your business. There are several advantages to registering your business as le
Introduction to Oracle PL/SQL
PL/SQL stands for Procedural Language/ SQL, and is a pretty sophisticated language used to access Oracle databases. It is integrated within the server environment to ensure smooth and fast execution of PL/SQL code or queries. The bigger part of this language is the SQL componen
Oracle Procedures, Functions and looping constructs
Procedures and functions in PL/SQL are types of blocks that are stored in the database in a compiled form. This is among the major differences between ordinary queries and procedures and functions (otherwise known as subprograms). Creating a function or procedure requires the u