Jan 4, 2010

Query to generate incremental numbers in Oracle

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:

SELECT     ROWNUM
      FROM DUAL
CONNECT BY LEVEL <= 30;


No comments:

Post a Comment