Skip to Main Content

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!

insert into .. select

Roger25Oct 3 2010 — edited Oct 3 2010
Hi,

I need to issue an insert into with the select clause. I know this is valid:
insert into (select a,b,c from table_1) values (......)
But is it possible to use a select into one of the 'values' columns, when using insert into .. values (...)?
So, insert into table_1 values (a,b,c, select .... , d)

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2010
Added on Oct 3 2010
5 comments
504 views