Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Comma delimited values into rows
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