Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL paste and insert problems

Re: PL/SQL paste and insert problems

From: <railies_at_cam.org>
Date: 1997/12/14
Message-ID: <3494D419.ED2@cam.org>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US