ALL_PLSQL_TYPES

ALL_PLSQL_TYPES describes the PL/SQL types accessible to the user.

Related Views

DBA_PLSQL_TYPES describes all the PL/SQL types in the database.
USER_PLSQL_TYPES describes the user's own PL/SQL types. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the type
`TYPE_NAME`	`VARCHAR2(136)`		Name of the type
`PACKAGE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the package containing the type
`TYPE_OID`	`RAW(16)`	`NOT NULL`	Object identifier (OID) of the type
`TYPECODE`	`VARCHAR2(58)`		Typecode of the type
`ATTRIBUTES`	`NUMBER`		Number of attributes in the type
`CONTAINS_PLSQL`	`VARCHAR2(3)`		Indicates whether the type contains PL/SQL-specific data types (`YES`) or not (`NO`)