view updation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: view updation

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    view updation

    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
    J Gangadhar

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    create or replace view .....


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

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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';
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width