Generate n rows from dual
I needed to generate exactly n rows and then this is very handy.
select * from (
select level lvl
from dual
connect by level <= N
)
Found at: http://awads.net/wp/2005/07/01/generating-n-rows-from-dual/
2 years ago
23. October 2009 12:44
2 years ago
