please refrain from lectures about normalization on this post...i have no
control over the table schema and am simply trying to normalize data
within
this shoddy flat-file type data table.
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
a row of data in this table 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.
tia,
steve
