SYS.ALL_IDENTIFIERS

Previous Next JavaScript must be enabled to correctly display this content

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