PL/SQL paste and insert problems
From: Yusuf <myusuf1_at_followme.com>
Date: 1997/12/14
Message-ID: <3494B54A.47090017_at_followme.com>#1/1
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.
etc. etc.
Date: 1997/12/14
Message-ID: <3494B54A.47090017_at_followme.com>#1/1
[Quoted] 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 CET