Posted by sivaraman @ Friday, April 13, 2007 | Labels:
SQL query to print numbers from dual without using union

Select rownum from (select 1 from dual group by cube(1,1,1,1)) where rownum<10;

Excerpt from Asktom
| Friday, April 13, 2007

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)