Wednesday, August 6, 2008

Oracle: How to generate N sequential numbers

How to generate N sequential numbers using sql

select level from
dual
connect by level < N

Replace N by whatever number you want.

select level from dual connect by level <> 50

No comments:

Post a Comment