Oracle教程 2023-03-22

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

本站中文解释

Oracle视图ALL_STORED_SETTINGS用于查看当前用户拥有的存储设置元数据。它提供了一个可以针对注册到当前用户（以其为拥有者）的任何存储设置来检索元数据的接口。

使用此视图可以检索具有随时间变化的存储设置元数据，例如参数、类型、枚举或结构的当前版本和历史版本的详细信息。

使用方法：

要查询ALL_STORED_SETTINGS视图，请执行以下查询：

SELECT * FROM ALL_STORED_SETTINGS;

这将从Oracle中检索所有存储设置元数据并将其显示在结果集中。如果要查询特定存储设置的元数据，可以使用WHERE子句来限制结果集。

官方英文解释

ALL_STORED_SETTINGS provides information about the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges.

Related Views

DBA_STORED_SETTINGS lists information about the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges. It also returns parameter information for all objects in the database and is accessible only to users with the SELECT_CATALOG_ROLE privilege.
USER_STORED_SETTINGS lists information about the persistent parameter settings for stored PL/SQL units, but only shows information about PL/SQL units owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Name of the database user owning the stored PL/SQL unit
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the PL/SQL unit
`OBJECT_ID`	`NUMBER`	`NOT NULL`	Object number of the PL/SQL unit
`OBJECT_TYPE`	`VARCHAR2(12)`		The type of PL/SQL unit: `PROCEDURE`, `FUNCTION`, `PACKAGE`, `PACKAGE` `BODY`, `TRIGGER`, `TYPE`, or `TYPE` `BODY`
`PARAM_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the parameter stored persistently with the PL/SQL unit
`PARAM_VALUE`	`VARCHAR2(4000)`		The `TO_CHAR()` representation of the value of the persistently stored parameter. The width of this column is operating system dependent; however, it is never less than `255`.
`ORIGIN_CON_ID`	`NUMBER`		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)

Note:

This view is deprecated in favor of the ALL_PLSQL_OBJECT_SETTINGS view. Oracle recommends that you use ALL_PLSQL_OBJECT_SETTINGS instead. ALL_STORED_SETTINGS is retained for backward compatibility only.

本站中文解释

官方英文解释

相关推荐