user_views
SQL> select * from user_views
2 where view_name = 'VW_SHSE_QYXX_ZLQS';
效果:
image.png
user_views表结构描述
SQL> desc user_views;
Name Type Nullable Default Comments
---------------- -------------- -------- ------- ----------------------------------------------------------
VIEW_NAME VARCHAR2(30) Name of the view
TEXT_LENGTH NUMBER Y Length of the view text
TEXT LONG Y View text
TYPE_TEXT_LENGTH NUMBER Y Length of the type clause of the object view
TYPE_TEXT VARCHAR2(4000) Y Type clause of the object view
OID_TEXT_LENGTH NUMBER Y Length of the WITH OBJECT OID clause of the object view
OID_TEXT VARCHAR2(4000) Y WITH OBJECT OID clause of the object view
VIEW_TYPE_OWNER VARCHAR2(30) Y Owner of the type of the view if the view is a object view
VIEW_TYPE VARCHAR2(30) Y Type of the view if the view is a object view
SUPERVIEW_NAME VARCHAR2(30) Y Name of the superview, if view is a subview
EDITIONING_VIEW VARCHAR2(1) Y An indicator of whether the view is an Editioning View
READ_ONLY VARCHAR2(1) Y An indicator of whether the view is a Read Only View