Skip to Main Content
Forums

Oracle Database Discussions

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!

adding a new column in a CREATE -- AS SELECT statement

681473Jan 23 2009 — edited Jan 23 2009
I am creating a table using a select from an existing table. I wish to also add one new column (with null values for all records). Is this possible? What would the syntax be for this column?

Thanks,
Kevin
This post has been answered by Aman.... on Jan 23 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2009
Added on Jan 23 2009
#general-database-discussions
4 comments
1,081 views