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

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.

tia,

steve

never mind...found an example.