Tutorial by Examples

SELECT ROWNUM NO FROM DUAL CONNECT BY LEVEL <= 10
/* This is a simple query which can generate a sequence of numbers. The following example generates a sequence of numbers from 1..100 */ select level from dual connect by level <= 100; /*The above query is useful in various scenarios like generating a sequence of dates from a given date. The ...

Page 1 of 1