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!

create Table AS select - Adding new additional columns

User_VSOG2Sep 27 2022 — edited Sep 27 2022

Hi,
I'm using commercial version of ORACLE SQL and I want to create a table from SELECT, with an additional new column in the final table-

CREATE TABLE NEW_TABLE (new_column char(1)) AS (SELECT col_1, col_2, col_3 FROM OTHER_TABLE);

But, this is throwing error, ORA-01773: may not specify column datatypes in this CREATE TABLE

Please guide on this

This post has been answered by Frank Kulash on Sep 27 2022

Jump to Answer

Added on Sep 27 2022

#sql

3 comments

2,225 views

2 mentions