how to add a column to already created view
i had created view earlier on some schema now agin i got a request to modify the view(add few more columns to same view), how can i proceed.
where to get the source code of earlier view created
Printable View
how to add a column to already created view
i had created view earlier on some schema now agin i got a request to modify the view(add few more columns to same view), how can i proceed.
where to get the source code of earlier view created
create or replace view .....
you can get the text from user_views or dba_views, or from your source control system :)
You can get the source code of a view from user_views/all_views.
SQL> set long 4000
SQL> select text from user_views where view_name='FOO';