Re: Parsing A String and Inserting

E. Scott wrote:

> I have a small table that looks like the following:
>
> TEST_TABLE_1
>
> TXN_ID NUM(9)
> STRINGFIELD VARCHAR2(90)
>
> If TXN_ID is 123 and STRINGFIELD is 333.444.5555.666.
>
> I need a procedure or function that will parse this string and insert
> rows in another table like this:
>
> TEST_TABLE_2
>
> TXN_ID SEQ_NUM NEW_STRING
> 123 1 333
> 123 2 444
> 123 3 5555
> 123 4 666
>
> I know the INSTR Function can be used in some kind of loop but I am
> not sure what combination of functions to use to know when end of
> string is hit or best method for optimization. Could be large volume
> of rows.
>
> Any help appreciated.
>
> Scott

Has all of the hallmarks of homework so you need to post what you have written so far. Then we will provide hints as how to proceed.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)