Tuesday, 22 May 2012

What is an identifier? | PL SQL

An identifier is the name of any constant, variable, cursor, exception, sub-program, and package within a PL/SQL block.
The maximum length of an identifier can be up to 30 characters. Identifier should always begin with an alphabetic character and it cannot be a reserved word or the name of a database table or column name. It cannot contain characters, such as hyphen, slashes, or spaces. Some of the invalid and valid identifiers are given as follows:
?    v_empname - invalid
?    V_empname - invalid
?    v_empname - invalid
?    v_empname - valid
?    v_empname -valid