Oracle教程 2023-02-23

Oracle 视图 ALL_PLSQL_TYPES 官方解释，作用，如何使用详细说明

ALL_PLSQL_TYPES 视图显示所有当前用户可见的Oracle Database本地和全局PL/SQL类型的定义。用户在调用相关的PL/SQL过程时，可以通过ALL_PLSQL_TYPES视图来查看每个类型的具体定义，确保自己的调用正确性。

要使用ALL_PLSQL_TYPES视图，可以通过SELECT语句来查询视图中的内容，并按照不同的需求进行条件查询。例如可以使用以下语句查询名字为“XXX”的PL/SQL类型：

SELECT * FROM ALL_PLSQL_TYPES WHERE TYPE_NAME = ‘XXX’;

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`)