Home -> Usenet -> comp.databases.oracle -> Re: View SQL code

Re: View SQL code

From: Swapan Jha <sjha_at_us.oracle.com>
Date: 1996/02/20
Message-ID: <4gdn8k$oc4_at_inet-nntp-gw-1.us.oracle.com>#1/1 







Hi,



    Try using these two tables to find out the sql script



SQL> desc all_views

 Name                            Null?    Type


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

 OWNER                           NOT NULL VARCHAR2(30)
 VIEW_NAME                       NOT NULL VARCHAR2(30)
 TEXT_LENGTH                              NUMBER
 TEXT                                     LONG
 
SQL> desc user_views
 Name                            Null?    Type


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

 VIEW_NAME                       NOT NULL VARCHAR2(30)
 TEXT_LENGTH                              NUMBER
 TEXT                                     LONG
 




  Hope this helps



    
  
  •   Swapan



Received on Tue Feb 20 1996 - 00:00:00 CET












Original text of this message