|
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
Navigation:
[Reply to this message]
|