蛤蟆 Oracle,19.蛤蟆的Oracle杂记——数据字典dba_views

19.蛤蟆的Oracle杂记——数据字典dba_views

视图dba_views:数据库中所有视图的文本

描述如下：

sys@PDB1> desc dba_views;

Name                                                           Null?  Type

------------------------------------------------------------- ------------------------------------

OWNER                                                       NOT NULL VARCHAR2(128)

VIEW_NAME                                             NOT NULL VARCHAR2(128)

TEXT_LENGTH                                                                NUMBER

TEXT                                                                        LONG

TEXT_VC                                                                 VARCHAR2(4000)

TYPE_TEXT_LENGTH                                                    NUMBER

TYPE_TEXT                                                             VARCHAR2(4000)

OID_TEXT_LENGTH                                                      NUMBER

OID_TEXT                                                               VARCHAR2(4000)

VIEW_TYPE_OWNER                                                    VARCHAR2(128)

VIEW_TYPE                                                            VARCHAR2(128)

SUPERVIEW_NAME                                                     VARCHAR2(128)

EDITIONING_VIEW                                                       VARCHAR2(1)

READ_ONLY                                                           VARCHAR2(1)

CONTAINER_DATA                                                       VARCHAR2(1)

BEQUEATH                                                             VARCHAR2(12)

ORIGIN_CON_ID                                                           NUMBER

列的各个属性描述：

OWNER：视图的拥有者

VIEW_NAME：视图名字

TEXT_LENGTH：视图文本长度

TEXT：视图文本。当行来自正确的容器中，可能返回正确的值

TEXT_VC：这个列可能会截断视图文本

TYPE_TEXT_LENGTH：视图的类型语句的长度

TYPE_TEXT：视图的类型语句

OID_TEXT_LENGTH：带WITH OID语句的视图的长度

OID_TEXT：带WITH OID语句的视图

VIEW_TYPE_OWNER：typed view的拥有者

VIEW_TYPE：视图是否一个typed view

SUPERVIEW_NAME：超级视图名字

EDITIONING_VIEW：保留将来使用

READ_ONLY：视图是否只读

CONTAINER_DATA：视图是否包含指定容器数据

BEQUEATH：可以是CURRENT_USER或者DEFINER。

ORIGIN_CON_ID：数据来源的容器的ID