oracle connect by level

Generation of sequence numbers using connect by stmt.

Here is the SQL.

select level from dual connect by level < 10;

Output

=====

1

2

3

4

5

6

7

8

9