2 ms·
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 everyt
by jaxn 18y ago
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.
- neilc 18y ago> 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).
- jaxn 18y agoThanks for the tip! The list of features that justify using a commercial database keeps getting shorter each year.