Oracle教程 2023-03-22

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

本站中文解释

Oracle视图 ALL_PROCEDURES 是用于查看当前用户可访问的所有存储过程的视图。此视图所显示的信息包括：存储过程的名称、所有者、当前签名（参数个数和类型）、定义日期和存储过程定义文本。

要使用 ALL_PROCEDURES 视图，可使用 SELECT 语句到视图中获取必要的信息。例如，如果要查询具有两个参数的存储过程：

SELECT procedure_name,owner,date_created FROM all_procedures WHEREsignature = ‘params 2’;

这将查询当前用户可以访问的具有两个参数的存储过程的名称，所有者和定义日期。

官方英文解释

ALL_PROCEDURES lists all functions and procedures that are accessible to the current user, along with associated properties. For example, ALL_PROCEDURES indicates whether or not a function is pipelined, parallel enabled or an aggregate function. If a function is pipelined or an aggregate function, the associated implementation type (if any) is also identified.

Related Views

DBA_PROCEDURES lists all functions and procedures available in the database, along with associated properties.
USER_PROCEDURES lists all functions and procedures owned by the current user, along with associated properties. It does not contain the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Owner of the procedure
`OBJECT_NAME`	`VARCHAR2(128)`	Name of the object: top-level function, procedure, or package name
`PROCEDURE_NAME`	`VARCHAR2(128)`	Name of the procedure
`OBJECT_ID`	`NUMBER`	Object number of the object
`SUBPROGRAM_ID`	`NUMBER`	Unique subprogram identifier
`OVERLOAD`	`VARCHAR2(40)`	Overload unique identifier
`OBJECT_TYPE`	`VARCHAR2(13)`	The typename of the object
`AGGREGATE`	`VARCHAR2(3)`	Indicates whether the procedure is an aggregate function (`YES`) or not (`NO`)
`PIPELINED`	`VARCHAR2(3)`	Indicates whether the procedure is a pipelined table function (`YES`) or not (`NO`)
`IMPLTYPEOWNER`	`VARCHAR2(128)`	Owner of the implementation type, if any
`IMPLTYPENAME`	`VARCHAR2(128)`	Name of the implementation type, if any
`PARALLEL`	`VARCHAR2(3)`	Indicates whether the procedure or function is parallel-enabled (`YES`) or not (`NO`)
`INTERFACE`	`VARCHAR2(3)`	`YES`, if the procedure/function is a table function implemented using the ODCI interface; otherwise `NO`
`DETERMINISTIC`	`VARCHAR2(3)`	`YES`, if the procedure/function is declared to be deterministic; otherwise `NO`
`AUTHID`	`VARCHAR2(12)`	Indicates whether the procedure/function is declared to execute as `DEFINER` or `CURRENT_USER` (invoker)
`RESULT_CACHE`	`VARCHAR2(3)`	Indicates whether the function is result–cached (`YES`) or not (`NO`)
`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)
`POLYMORPHIC`	`VARCHAR2(5)`	The type of polymorphic table function: `ROW` `TABLE` `LEAF` `NULL`
`SQL_MACRO`^Foot 1	`VARCHAR2(6)`	Indicates whether the procedure is a SQL macro. Possible values: `SCALAR`: The procedure is a SQL macro for a scalar expression `TABLE`: The procedure is a SQL macro for a table expression `NULL`: The procedure is not a SQL macro
`BLOCKCHAIN`^Foot 1	`VARCHAR2(3)`	For internal use only
`BLOCKCHAIN_MANDATORY_VOTES`^Foot 1	`VARCHAR2(4000)`	For internal use only

^Footnote 1This column is available starting with Oracle Database 21c.

本站中文解释

官方英文解释

相关推荐