Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter View Add Column

732390Dec 10 2009 — edited Mar 31 2011
I want to add a column to view.

ALTER VIEW view_name
ADD column_name

ALTER VIEW view_name
("column 1", "col 2", "col3", "col4")
SELECT ("col5", "col6", "col7", "col8")
FROM table_name

Can anyone say me how the syntax should be
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2011
Added on Dec 10 2009
7 comments
19,317 views