美文网首页
ORACLE查询某视图

ORACLE查询某视图

作者: 周紫一 | 来源:发表于2018-07-06 15:19 被阅读8次

    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   
    

    相关文章

      网友评论

          本文标题:ORACLE查询某视图

          本文链接:https://www.haomeiwen.com/subject/tkxbuftx.html