PL/SQL paste and insert problems

From: Yusuf <myusuf1_at_followme.com>
Date: 1997/12/14
Message-ID: <3494B54A.47090017@followme.com>#1/1

hi everybody,

here is my PL/SQL problems...

I have two tables

the first table
table temp has 2 columns (item_no number, description varchar2 (100))

   item_no            description
    102                    ABC AD ASDD EDS AD
    104                    AB DCS CD XSDF
     ...                       ...............................
     ...                      ...  .............................

the second table temp1 has 2 columns ( item_no number, descriptio varchar (8) ).
I want to insert temp value in such a way by reading item_no and each characters
and insert into temp1 i.e for every item_no cut and insert multiple values as descriped.

temp1 table should be

item_no description

102         ABC
102         AD
102         EDS

etc. etc.

hints ---I have been trying to deal with this problems use cursor loop, substr, instr
or
any suggestion or alternatives

Thanks

Mohamed Yusuf Received on Sun Dec 14 1997 - 00:00:00 CST