Re: Comma delimited values into rows

From: Jim Kennedy <jim>
Date: Tue, 9 May 2006 22:00:15 -0700
Message-ID: <TZ6dnd0KqNCH7vzZnZ2dnUVZ_tydnZ2d@comcast.com>

"johnv" <jverburgt_at_cme.com> wrote in message news:1147228657.310936.108380_at_j33g2000cwa.googlegroups.com...
> I have this string in a field called 'ID':
>
> 1000,1001,1002,...n
>
> In sql only, how can i write a view that treats the comma as a new row
> so that my result set reads as:
>
> ID
> -------
> 1000
> 1001
> 1002
>

Actually you can turn this into a type and cast the type to a table ( the_type) search on asktom.oracle.com
Jim Received on Wed May 10 2006 - 00:00:15 CDT

This message: [ Message body ]
Next message: Michel Cadot: "Re: oracle 8.1 "expression must have same datatype as corresponding expression""
Previous message: senthil: "reg: help need for which books to prefer"
In reply to: johnv: "Comma delimited values into rows"
Next in thread: fitzjarrell_at_cox.net: "Re: Comma delimited values into rows"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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