Re: convert delimited string to rows ?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 03 Jun 2002 15:37:55 GMT
Message-ID: <3CFB8D4F.5B2E27BD@exesolutions.com>

Sunil wrote:

> I have a string
> 'rob:bob:tod:rod:mod'
>
> can I use any function to convert this into rows so that I can do something
> like
> SQL> select * from some_funct('rob:bob:tod:rod:mod')
>
> and get :-
>
> rob
> bob
> tod
> rod
> mod
>
> 5 rows selected.
>
> as output ?
>
> Thanks,
> Sunil.

If you use REPLACE to replace the colons with commas you could turn it all into a PL/SQL table with DBMS_UTILITY.COMMA_TO_TABLE.

Daniel Morgan Received on Mon Jun 03 2002 - 10:37:55 CDT