Pivot Tables in Oracle
This trick is a fast and efficient method for generating a set with any number of rows:

SELECT level
FROM dual
CONNECT BY level <= 100 # row count


• Mini Sitemap:

• Post to Journal
• Downloads

• LJ Gift Shop
• Safety Tips

• Support & FAQs
• Be a Support Volunteer

• Feedback & Contact Us
• Report Abuse

• Site News
• More... (Full Sitemap)