Small tip to generate incremental numbers that developers need it sometimes.
So if I want to generate numbers from 1 to 30, I will write:
So if I want to generate numbers from 1 to 30, I will write:
SELECT ROWNUM
FROM DUAL
CONNECT BY LEVEL <= 30;