select from column-separated list
This is asked over and over in the forums, but why not proposing an 11g solution here create table t(description varchar2(12) primary key, numbers varchar2(4000)); insert into t(description, numbers) values ('PRIME','2,3,5,7'); insert into t(description, numbers) values ('ODD','1,3,5,7,9'); commit; DESCRIPTION NUMBERS PRIME 2,3,5,7 ODD 1,3,5,7,9 Now I want to unpivot numbers in rows select description,(column_value).getnumberval() from [...]