DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: altering views ?

  1. #1
    Join Date
    Nov 2001
    Posts
    27
    Could anyone tell me if there is a way to drop a column from a view ?

    SQL>alter view VIEW_NAME drop column COLUMN_NAME;
    ---- will not work.

    **Or, better yet, I would like to move all the data from a view into a table so then I can modify the table with no problems.

    PLEASE HELP.

    Im using Oracle8i on Linux Red Hat

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Why do you want to Alter a view?
    Just recreate it.

    Regards

    Angel

  3. #3
    Join Date
    Nov 2001
    Posts
    27
    I can drop the column by recreating the view, but I also need
    to copy the data from one column to another.

    How do I do this ?

  4. #4
    Join Date
    Dec 2001
    Posts
    19
    Hi,

    A view does not actually store the data like a table would. A view is simply a reference to particular columns in a table or tables.

    So there is no need to copy data from one column to another, simply drop the current view and re-create it exactly the way you want manipulating the select statement within the create view.

    KASH

  5. #5
    Join Date
    Nov 2001
    Posts
    27
    ok thanks

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