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!

MERGE function - on a temporary target table

672951Jan 12 2009 — edited Jan 12 2009
Hi,

Can we merge into a table which is basically a temporary table created using a select statement?

For e.g.

MERGE INTO (Select a,b,c from test) tmp....

Please suggest.

Thanks in advance.

Annie
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2009
Added on Jan 12 2009
#with
4 comments
442 views