PL/SQL help

Hi all,

I have the follwoing table (abc):

NAME         NO_CASES
---------          -------------------

Smith            13
John              9
Mary              5
Kate              23

I want to insert into another table (xyz) as follows:

Smith must be inserted 13 times (13 rows), John 9 times (9 rows) etc.. for all the records in the table.

How will I do this?

Thanks in advance... Received on Thu Sep 28 2006 - 02:27:38 CDT