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) INLINE	Identifier owner
NAME	VARCHAR2(30) INLINE	Identifier name
SIGNATURE	CHAR(32)	Signature of the identifier
TYPE	VARCHAR2(18) INLINE NOT NULL	Identifier type
OBJECT_NAME	VARCHAR2(30) INLINE	Name of the object where the identifier action occurred
OBJECT_TYPE	VARCHAR2(12) INLINE NOT NULL	Type of the object where the identifier action occurred
USAGE	VARCHAR2(11) INLINE 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