ALL_IDENTIFIERS

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

Related Views

DBA_IDENTIFIERS displays information about the identifiers in all stored objects in the database.
USER_IDENTIFIERS displays information about the identifiers in the stored objects owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the identifier
`NAME`	`VARCHAR2(128)`		Name of the identifier
`SIGNATURE`	`VARCHAR2(32)`		Signature of the identifier
`TYPE`	`VARCHAR2(18)`		Type of the identifier
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object where the identifier action occurred
`OBJECT_TYPE`	`VARCHAR2(13)`		Type of the object where the identifier action occurred
`USAGE`	`VARCHAR2(11)`		Type of the identifier usage: `DECLARATION` `DEFINITION` `CALL` `REFERENCE` `ASSIGNMENT`
`USAGE_ID`	`NUMBER`		Unique key for the identifier usage within the object
`LINE`	`NUMBER`		Line number of the identifier action
`COL`	`NUMBER`		Column number of the identifier action
`USAGE_CONTEXT_ID`	`NUMBER`		Context `USAGE_ID` of the identifier usage
`ORIGIN_CON_ID`	`VARCHAR2(256)`		The ID of the container where the data originates. Possible values include: `0`: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)