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 ...
