In Oracle 9i and above, the following returns N number of rows:
select * from (
select level lvl
connect by level <= N
This can sometimes come in handy in your SQL statements.
[…] I found this useful tip on Eddie Awad’s blog . He left a comment on mine and that’s how I found him. He’s an Oracle application developer and runs quite an interesting blog. Shouldn’t he be on OraBlogs? […]
RSS - Posts
RSS - Comments