Order by comma separated number values???
I have following table
create table ord as
(select '4,7,10' col1
union
'4,7,8'
union
'5,6,11'
union
'4,7,10'
union
'4,7,6'
union
'4,7,7'
from dual)
I want to say select * from ord order by col1 and the order by should look at each number in the column vs ordering it by string...
Currently 4,7,10 comes up first(as it does a string comparision) but I want 4,7,6 to come up first.