oracle connect by rownum

Generation of sequence numbers using connect by stmt.

Here is the SQL.

select rownum from dual connect by rownum < 10;

Output

======

1

2

3

4

5

6

7

8

9