Thread: A View Doubt

We can see code in procedure, functions and triggers using ALL_SOURCE. But How to see a query assosiated with a view?

Use sys.All_views

You many not have priviliges to select from All_views . Use User_views instead.

I have given the following command

select text from all_views
where view_name='FM_CURRENCY';

I was able to view first two lines only. How to view entire query?

you can see that in the user_views and dba_views or all_views

Originally Posted by krishnaindia2007

I have given the following command

select text from all_views
where view_name='FM_CURRENCY';

I was able to view first two lines only. How to view entire query?

you just set the long parameter

sql> set long 2000;