Some functionality like selecting from dynamic table column-rows.... like .. "select term from table(term(rowvalues('Week1', 'Week2'...'Week5')) from dual" or something like that
select 'Week1' as term from dual UNION select 'Week2' as term from dual UNION .... ....
Thank you Jineesh..sorry that I didn't post exact values that I need
Just looking for how to select the above in one single SQL without UNION
select decode(level, 1,'O/N', 2,'1W', 3,'2W', 4,'1M', 5,'2M', 6,'3M') wk from dual connect by level <= 6; WK --- O/N 1W 2W 1M 2M 3M 6 rows selected