Quick Start: Git for personal use
SVN client over SSH to remote Unix server from Windows
Quick Start Grinder - Part V
Quick Start Grinder - Part IV
Quick Start Grinder - Part III
« Back again
» QOTD
Updates at 7:30 PM below.
Just an observation, but START WITH .. CONNECT BY has been in Oracle since about release 6.
It was certainly in the first version I used (6.0.36 if memory serves) because I used it to build a BOM type application.
Its a valuable addition to SQL and I would love to see it in one or more of the open source databases.
True... I've used it from 7.3 onwards. I too used it for a BOM.
One thing I find missing in Oracle's implementation is the inability to make joins while using CONNECT BY. Since 8i, this is not an issue since you can put a query as part of FROM clause.