sql query to list 1..25 numbers.
Hi all,
How could I write a query (not pl/sql) to generate a series fo numbers.
Don't take any dependent tables, meant if i have a table with more than 100 rows then by writing "select rownum from mytable where rownum<101; will gives the results what i required.
But I am looking for a query which is indipendet of other tables , ofcourse you can use DUAL or any standard functions.
Thanks in advance,
Khaleel.