Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL paste and insert problems
Yusuf wrote:
>
> 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.
the problem in essence is not complicated as you have to track the space and cut the word between 2 consecutive spaces (setting the first space on position 0 of the string) - but I don't understand how will you avoid the value ASDD from 102 - what's the logic - or is it a miss ?
Razvan Iliescu Received on Sun Dec 14 1997 - 00:00:00 CST