Oracle教程 2023-03-21

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

本站中文解释

ALL_VIEWS_AE视图是Oracle的一种定义数据库视图的方法，可以将一些重复使用的查询语句放在一个存储在数据库中的视图上，这样，在后续使用时可以直接引用该视图，而不用再次输入完整的查询语句。

具体使用方法：

1、在ALL_VIEWS_AE视图表中创建视图。

2、把所需要的SQL语句以SELECT开头作为视图的定义语句，放入视图表中。

3、要查询视图，只需使用SELECT *FROM ViewName即可得到正确的结果。

官方英文解释

ALL_VIEWS_AE describes the views (across all editions) accessible to the current user.

Related Views

DBA_VIEWS_AE describes all views (across all editions) in the database.
USER_VIEWS_AE describes the views (across all editions) 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. 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 an 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, if the view is a subview
`EDITIONING_VIEW`	`VARCHAR2(1)`		Indicates whether the view is an editioning view (`Y`) or not (`N`)
`READ_ONLY`	`VARCHAR2(1)`		Indicates whether the view is read-only (`Y`) or not (`N`)
`EDITION_NAME`	`VARCHAR2(128)`		Name of the application edition where the object is defined
`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`	`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)
`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

本站中文解释

官方英文解释

相关推荐