Re: retrieve view SQL Statement

"Jean" <ken_jean_at_hotmail.com> wrote in message news:9nsgvr$aoq$1_at_serv1.iunet.it...

> Hi to everyone!!
> I have a view called SearchCandidates.
> Now I need to retrieve its SQL Statement.

you forgot it ? ok, you're lost ...

just joking ...

> 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?

set pagesize 0
set long 5000
set linesize 600
set wrap on
col text format a130
select substr(owner||'.'||view_name,1,40) "View"

        ,text
from all_views
where view_name like upper('%&viewname%') /

> Thanks a lot in advance
> Bye

Hth
Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG