Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

The Lexical Set of Elements

The PL/SQL lexical set of elements consists of identifiers, delimiters, literals, and comments. Identifiers are names of PL/SQL program items and units. These items and units could be of different kinds - constants, variables, exceptions, cursors, cursor variables, subprograms, and packages. An identifier cannot exceed 30 characters. An identifier consists of a letter optionally followed by more letters, numerals, dollar signs, underscores, and number signs. By default, identifiers are not case sensitive. Identifiers may not be the same as reserved words, so you cannot use the word end as a variable name.