Re: Comma delimited values into rows

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 11 May 2006 21:20:02 +0200
Message-ID: <44638e69$0$295$626a54ce@news.free.fr>

"johnv" <jverburgt_at_cme.com> a écrit dans le message de 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
|

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:60446839951079

Regards
Michel Cadot Received on Thu May 11 2006 - 14:20:02 CDT