How to do number generation using sql oracle 10 g?

Question

Oracle

example
sqlfiddle.com/#!4/b6b27/5
10g only does not support parameters in the WITH construct
Can be done without parameters: WITH cte as {}

Answer 1

In Oracle, hierarchical queries are usually done differently:

SELECT level
FROM DUAL
CONNECT BY level < 100