Re: know how to parse data from single column??

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 30 Oct 2002 00:11:34 GMT
Message-ID: <3DBF23B4.ABACBF82@exesolutions.com>

Mike Cohen wrote:

> Hello,
>
> I have a query that is selecting a column where the data is as such:
>
> 1|5|6
> 3|11|12|7
>
> ...etc...
>
> essentially the specific data points within the column are all
> seperated by pipes.
>
> Anyone know how to select out these specific data points so they
> appear in, ideally, their own columns?
>
> Thanks,
>
> Mike

The easiest way is to use TRANSLATE to turn the pipes into commas and then break it up with DBMS_UTILITY.COMMA_TO_TABLE. Otherwise use INSTRing and SUBSTRing to parse it yourself.

Daniel Morgan Received on Tue Oct 29 2002 - 18:11:34 CST