Duplicate/Replicate data in table
Posted on 2014-02-04
I have a table of 10,000 rows that I need to multiply into 200,000. I basically want to take the data I have in the table duplicate it until there are 200,000 rows, but the empl id needs to be unique so I plan on using a sequence to create it. Basic table structure below
Emplid case case_desc
1 open this case is open
2 closed this case is closed
3 open this case is open
Should I justinsert into case a (select seq.nxtval, case, case_desc from case b); until I reach 200K or is this a more efficient way.