SYS.ALL_IDENTIFIERS

The ALL_IDENTIFIERS view displays information about the identifiers in the stored objects accessible to the current user.

Related views

SYS.DBA_IDENTIFIERS displays information about the identifiers in all stored objects in the database. It has the same columns as ALL_IDENTIFIERS.
SYS.USER_IDENTIFIERS describes the identifiers for all stored objects that are owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2 (30) NOT NULL	Identifier owner.
NAME	VARCHAR2 (30)	Identifier name.
SIGNATURE	CHAR (32)	Signature of the identifier.
TYPE	VARCHAR2 (18) NOT NULL	Identifier type.
OBJECT_NAME	VARCHAR2 (30) NOT NULL	Name of the object where the identifier action occurred.
OBJECT_TYPE	VARCHAR2 (13) NOT NULL	Type of the object where the identifier action occurred.
USAGE	VARCHAR2 (11) NOT NULL	Type of the identifier usage (Declaration, Definition, Call, Reference, Assignment).
USAGE_ID	TT_INTEGER	Unique key for the identifier usage within the object.
LINE	TT_INTEGER	Line number of the identifier action.
COL	TT_INTEGER	Column number of the identifier action.
USAGE_CONTEXT_ID	TT_INTEGER	Context USAGE_ID of the identifier usage.