Multi-Rows from DUAL
I need an easy select from DUAL, which gives me more than one row.
e.g. 1000 rows or 4500 rows....
I know that one of the best solutions was something with an CONNECT BY PRIOR and a WHERE ROWNUM <= 1000 e.g.
But what was the complete statement?
thx 4 solutions
Gerd