Oracle教程 2023-02-23

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

本站中文解释

Oracle视图是从多个表中检索出来的报表或其他信息，也可以说是虚拟表，视图把“虚拟表”绑定成一张实际的表格面向用户，这样，用户可以直接查询虚拟表，而不用关心它是如何根据哪些物理表组成的。

ALL_VIEWS是系统视图，它仅提供与当前用户拥有的特定元数据的详细信息。它可以用于检索当前用户所拥有的所有视图的信息，如视图的定义代码、其中的使用的列及其他的属性信息。

要使用ALL_VIEWS视图，可以使用以下查询：

select * from all_views;

官方英文解释

ALL_VIEWS describes the views accessible to the current user.

Related Views

DBA_VIEWS describes all views in the database.
USER_VIEWS describes the views owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the view
`VIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the view
`TEXT_LENGTH`	`NUMBER`		Length of the view text
`TEXT`	`LONG`		View text. This column returns the correct value only when the row originates from the current container. The `BEQUEATH` clause will not appear as part of the `TEXT` column in this view.
`TEXT_VC`	`VARCHAR2(4000)`		View text. This column may truncate the view text. The `BEQUEATH` clause will not appear as part of the `TEXT_VC` column in this view.
`TYPE_TEXT_LENGTH`	`NUMBER`		Length of the type clause of the typed view
`TYPE_TEXT`	`VARCHAR2(4000)`		Type clause of the typed view
`OID_TEXT_LENGTH`	`NUMBER`		Length of the `WITH OID` clause of the typed view
`OID_TEXT`	`VARCHAR2(4000)`		`WITH OID` clause of the typed view
`VIEW_TYPE_OWNER`	`VARCHAR2(128)`		Owner of the type of the view if the view is a typed view
`VIEW_TYPE`	`VARCHAR2(128)`		Type of the view if the view is a typed view
`SUPERVIEW_NAME`	`VARCHAR2(128)`		Name of the superview
`EDITIONING_VIEW`	`VARCHAR2(1)`		Reserved for future use
`READ_ONLY`	`VARCHAR2(1)`		Indicates whether the view is read-only (`Y`) or not (`N`)
`CONTAINER_DATA`	`VARCHAR2(1)`		Indicates whether the view contains container-specific data. Possible values: `Y` if the view was created with the `CONTAINER_DATA` clause `N` otherwise
`BEQUEATH`	`VARCHAR2(12)`		Possible values: `CURRENT_USER`: When the view is a `BEQUEATH CURRENT_USER` view `DEFINER`: When the view is a `BEQUEATH DEFINER` view For more information about the syntax and semantics of the `BEQUEATH` clause in the SQL `CREATE VIEW` statement, see Oracle Database SQL Language Reference.
`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)
`DEFAULT_COLLATION`	`VARCHAR2(100)`		Default collation for the view
`CONTAINERS_DEFAULT`	`VARCHAR2(3)`		Indicates whether the view is enabled for `CONTAINERS()` by default (`YES`) or not (`NO`)
`CONTAINER_MAP`	`VARCHAR2(3)`		Indicates whether the view is enabled for use with the `container_map` database property (`YES`) or not (`NO`)
`EXTENDED_DATA_LINK`	`VARCHAR2(3)`		Indicates whether the view is enabled for fetching an extended data link from the root (`YES`) or not (`NO`)
`EXTENDED_DATA_LINK_MAP`	`VARCHAR2(3)`		For internal use only
`HAS_SENSITIVE_COLUMN`	`VARCHAR2(3)`		Indicates whether the view has one or more sensitive columns (`YES`) or not (`NO`)
`ADMIT_NULL`	`VARCHAR2(3)`		Indicates whether the view admits null `CON_ID` data (`YES`) or not (`NO`)
`PDB_LOCAL_ONLY`	`VARCHAR2(3)`		For internal use only

本站中文解释

官方英文解释

相关推荐