Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> retrieve view SQL Statement

retrieve view SQL Statement

From: Jean <ken_jean_at_hotmail.com>
Date: Fri, 14 Sep 2001 10:59:43 +0200
Message-ID: <9nsgvr$aoq$1@serv1.iunet.it> 





Hi to everyone!!


I have a view called SearchCandidates.


Now I need to retrieve its SQL Statement.
I know that are tables that contains metadata. For example user_tab_columns
contains columns list for each table or view in database.
Is there another table that contains views SQL Statement?



Thanks a lot in advance


Bye
Received on Fri Sep 14 2001 - 03:59:43 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US