Re: View SQL code

raz_at_opus.freac.fsu.edu wrote:
>
> Hello,
>
> A previous employee created a View which is used by a couple of programs.
> The view was not documented and we need to see what's the SQL code of the
> view.
>
> How can I view this code? A describe <view_name> only shows the fields
> of the view. I need to see the actual SQL code.You can select from one of the dictionary-views called user_views, all_views or
dba_views depending on the circumstances.

Example in sqlplus:
set arraysize 1
set long 10000
select text from user_views where view_name = 'YOURVIEW';

Hope that helped.

-- 
Oliver Felix Fox
Dansk Data Elektronik A/S,
Herlev Hovedgade 199, DK-2730 Herlev, Denmark
E-mail: off_at_dde.dk