CONNECT BY PRIOR on the other hand can be a life saver.
There are projects where I really love using Oracle (and to a lesser degree SQL Server). It has everything to do with features that solve problems.
I loathe DB2 though. Also, there are some weird smaller commercial databases like Pervasive that seem to add nothing but difficult interfaces.
> CONNECT BY PRIOR on the other hand can be a life saver.
FWIW, the latest beta release of PostgreSQL supports recursive queries (using the SQL standard WITH RECURSIVE rather than CONNECT BY, but still).
Can you get your money's worth out of a database like Oracle? I think you absolutely can if you USE the features it comes with. If you don't want to do that, or don't need those features, then you are throwing your money away.