Skip to Main Content

SQL Developer

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!

Multiple rows insertion - need help

927588Feb 20 2013 — edited Feb 20 2013
Hello all,

I need to insert multiple rows in the table with a single query and the number of rows is 269470.
Here one of the columns is determined by another sub query which returns multilple rows and the other 2 columns remain same for all.

I came up with the following query but need a loop to make it run multiple time(269470 times).

insert into EMLUSRRECV
(user_id, storeent_id, receiveml)
values
(+(select user_id from users where user_id not in (select distinct user_id from EMLUSRRECV) and CURR = 'USD' and rownum = 1)+, 11154, 1);

Thanks in advance.
This post has been answered by unknown-7404 on Feb 20 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2013
Added on Feb 20 2013
2 comments
130 views