ORACLE查询某视图

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