请教如何用SQL得到用户建立的视图？谢谢

Question

select * from dba_objects 
where object_type='VIEW' and owner='username '

Answer 1

09:45:40 jlanzpa817>desc all_views
 名称                                      空?      类型
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 VIEW_NAME                                 NOT NULL VARCHAR2(30)
 TEXT_LENGTH                                        NUMBER
 TEXT                                               LONG
 TYPE_TEXT_LENGTH                                   NUMBER
 TYPE_TEXT                                          VARCHAR2(4000)
 OID_TEXT_LENGTH                                    NUMBER
 OID_TEXT                                           VARCHAR2(4000)
 VIEW_TYPE_OWNER                                    VARCHAR2(30)
 VIEW_TYPE                                          VARCHAR2(30)

Answer 2

SQL> select view_name from all_views where owner='ZDWY';VIEW_NAME
------------------------------
EXPERTBC_VIEW
EXPERTBC_VIEW1
EXPERT_VIEW
EXPERT_VIEW1
FORUM1_VIEW
FORUM2_VIEW
MEDICINE_VIEW
NEWSHEALTH_VIEW
NEWSINDEX_VIEW9 rows selected

Answer 3

10:42:55 jlanzpa817>create view aaaaa as select * from tab;视图已建立。已用时间:  00: 00: 00.20
10:43:14 jlanzpa817>select text from all_views where VIEW_NAME = 'AAAAA';TEXT
-------------------------------------------------------------------------------
select "TNAME","TABTYPE","CLUSTERID" from tab已用时间:  00: 00: 00.90
10:43:50 jlanzpa817>DESC aaaaa
 名称                                      空?      类型
 ----------------------------------------- -------- ---------------------------
 TNAME                                     NOT NULL VARCHAR2(30)
 TABTYPE                                            VARCHAR2(7)
 CLUSTERID                                          NUMBER

Answer 4

select text from all_views where view_name='视图名';

Answer 5

select tname ，cname from col where tname =‘视图名'；
SQL> desc col;
 名称                                     
 -----------------------------------------
 TNAME                                    
 COLNO                                    
 CNAME                                    
 COLTYPE                                        
 WIDTH                                    
 SCALE                                          
 PRECISION                                      
 NULLS                                          
 DEFAULTVAL                                     
 CHARACTER_SET_NAME