CODE EXAMPLE FOR SQL

oracle generate sequence of numbers

SQL> SELECT LEVEL 
FROM dual
CONNECT BY LEVEL <= 100; --You can select numbers from 1 to 100.