Identifier's

IDENTIFIERS

Identifiers are used to name PL/SQL objects, such as variables, cursors, types and subprograms. Identifiers consists of a letter, optionally followed by any sequence of characters, including letters, numbers, dollar signs, underscores, and pound signs only. The maximum length for an identifier is 30 characters.

QUOTED IDENTIFIERS

If you want to make an identifier case sensitive, include characters such as spaces or use a reserved word, you can enclose the identifier in double quotation marks.

Ex:

                          DECLARE

        "a" number := 5;

        "A" number := 6;

  BEGIN

        dbms_output.put_line('a = ' || a);

        dbms_output.put_line('A = ' || A);

  END;       

Output:

  a = 6

  A = 6