Thursday, June 7, 2007

How to generate Serial Number By using SQL

SELECT *
FROM (SELECT LEVEL as "SR Number"
FROM DUAL
CONNECT BY LEVEL <= 15)
this will generate sequence from 1 to 15