Determining identifier types and usages

A lexical unit in a PL/SQL program code is built up using literals, identifiers, delimiters, and comments. All items that are declared in a PL/SQL program as variables, cursors, constants, and subprogram names are identifiers. Identifiers can be reserved words (such as BEGIN and END), predefined (declared globally within STANDARD package), or quoted.

USER_IDENTIFIERS

The USER_IDENTIFIERS dictionary view reports the usage of identifiers in a PL/SQL program unit. The view includes information about an identifier's name, its type, and usage by line number in a PL/SQL program.

Tracking identifier details for all the subprograms would be additional task during code compilation and therefore, it is collected only for enabled PL/SQL objects.

The structure of the USER_IDENTIFIERS view is as follows:

Name          Null?      Type
------------- ---------- ------------------------
NAME                     VARCHAR2(128)
SIGNATURE                VARCHAR2(32)
TYPE  ...