We can see code in procedure, functions and triggers using ALL_SOURCE. But How to see a query assosiated with a view?
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