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!

insert same row multiple times

R. RoyalOct 9 2008 — edited Oct 9 2008
Hi,
I've this table TAB1:

COD.........TYPE........DESCRIP
1..............RED..............MY COLOR


I'd like to insert into table TAB2 this record 10000 times

How can I write my insert or procedure to insert this row multiple times?

Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2008
Added on Oct 9 2008
5 comments
3,503 views