select column_value from TABLE (sys.odcinumberlist(1,2,3,4,5));
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as apps
SQL> select column_value as val from TABLE (sys.odcinumberlist(1,2,3,4,5));
VAL
----------
1
2
3
4
5
SQL>
Интересный способ…
—
Подскажу еще один, юзаю довольно часто.
select level n from dual
connect by level <= 5;