view updation

[ganga]

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

[davey23uk]

create or replace view .....


you can get the text from user_views or dba_views, or from your source control system

[kris109]

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';