Posted by steve on 06/15/05 02:49

not getting a response from oracle ngs...hope the post here is not
objectionable.

i've got a table that's basically:

create table foo
(
id number
values varchar2(32767)
)

the values column contains space-seperated data like:

A B C D

so the table data would look like:

id values
________________

1 A B C D

i need a query that would return:

id values
____________________

1 A
1 B
1 C
1 D

basically, for each id i need to return a row for each value in the values
column. any help with this would be much appreciated!

tia,

steve

[Back to original message]