Re: Stored Procedure Help!!!

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Tue, 26 Sep 2000 14:25:57 -0700
Message-ID: <8qr492$ji0$1@spiney.sierra.com>

select substr(a_field,1,15) part from table1 union
select substr(a_field,16,15) part from table1 /

"Vivek Dabholkar" <vivek_dabholkar_at_my-deja.com> wrote in message news:8qqm6i$4qk$1_at_nnrp1.deja.com...
> I am writing an Oracle stored procedure. Procedure is accepting a
> string as a parameter. The string is in the following format.
>
> '1111,1111,1111;2222,2222,2222;'.
>
> I need to parse this string inside the procedure and manipulate the
> data.
>
> I wanted to parse the string in such a way that I can define a cursor
> and which will return me the result in the form of recordset.
>
> For Example: SELECT somefunc
> ('1111,1111,1111;2222,2222,2222;', ';') 'Records' FROM DUAL;
> Result of the query:
> Records
> ----------------------
> 1111,1111,1111;
> 2222,2222,2222;
>
>
> If I get this working I can easily manipulate the result set.
>
> Can anyone help me to find "somefunc" from above query, please.
>
>
> Thanks a lot in advance.
>
> -Vivek.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Sep 26 2000 - 16:25:57 CDT