-
Book Overview & Buying
-
Table Of Contents
Advanced Oracle PL/SQL Developer's Guide (Second Edition) - Second Edition
By :
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.
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 ...
Change the font size
Change margin width
Change background colour