Identifiers
Identifiers provide a named reference to PL/SQL objects such as variables and cursors, and to database objects, including procedures, functions, and packages.
The identifier allows the object to be referenced by name rather than by someOracle internal reference.
An identifier consists of a letter optionally followed by more letters, numerals, dollar signs, underscores, and number signs. Other characters such as hyphens, slashes, and spaces are not allowed.
Restrictions on identifier names include:
■ Names must be 30 characters or less.
■ Names must start with a letter.
■ Names can contain the following characters as long as they are not the first
character in the name: $, #, _, and any number.
■ Names cannot contain punctuation, spaces, or hyphens.
PL/SQL is not case sensitive. Two identifiers with the
same name but different case are the same, so use unique names, or unique prefixes for identifiers to avoid reusing the same name.
The following identifier names are valid:
My_Procedure
Variable1
cursor_#1
Function_4_$
The following identifiers are not valid:
My-Procedure
1Variable
cursor #1
Function_@_name
Identifiers should be descriptive. Avoid obscure names such as emp_first_name,emp_salary etc.
There are 30 characters to work with, leaving plenty of space to create a descriptive name
