SELECT *
FROM (SELECT LEVEL as "SR Number"
FROM DUAL
CONNECT BY LEVEL <= 15)
this will generate sequence from 1 to 15
This blog shifted to http://oracleebusinesssuite.wordpress.com
Continuous effort--not strength or intelligence--is the key to
unlocking our potential.
The most powerful and predictable people-builders are praise and encouragement.