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


本站中文解释

Oracle视图ALL_ASSEMBLIES提供使用当前用户schema定义的程序集(assemblies)的摘要信息,它是关于使用外部程序直接调用程序执行存储在数据库中的函数和过程的名称、类型和所需参数等信息的详细清单。

使用ALL_ASSEMBLIES视图可以查询和获取当前用户schema定义的程序集,以及关联的函数和参数、版本、创建者等信息。可以通过如下语句访问此表:

SELECT * FROM All_Assemblies;

官方英文解释

ALL_ASSEMBLIES provides information about assemblies accessible to the current user.

Related Views

  • DBA_ASSEMBLIES provides information about all assemblies in the database.

  • USER_ASSEMBLIES provides information about all assemblies owned by the current user. This view does not display the OWNER column.

ColumnDatatypeNULLDescription

OWNER

VARCHAR2(128)

NOT NULL

Owner of the assembly

ASSEMBLY_NAME

VARCHAR2(128)

NOT NULL

Name of the assembly

FILE_SPEC

VARCHAR2(4000)

Operating system file specification of the assembly

SECURITY_LEVEL

VARCHAR2(10)

The maximum security level of the assembly

IDENTITY

VARCHAR2(4000)

The identity of the assembly

STATUS

VARCHAR2(7)

Status of the assembly

See Also:

  • “DBA_ASSEMBLIES”

  • “USER_ASSEMBLIES”