4 ms·
This. I've done (1) nested sets, (2) recursive CTEs, and (3)the magic Oracle fairy dust of CONNECT BY and STARTS WITH. (1) and (2) seem to make my coworkers (
by tom_b 16y ago
This.
I've done (1) nested sets, (2) recursive CTEs, and (3)the magic Oracle fairy dust of CONNECT BY and STARTS WITH.
(1) and (2) seem to make my coworkers (and bosses) eyes' glaze over. I think they like (3) because they don't have to worry as much about "code that guy in the corner wrote."
- mcantor 16y agoCONNECT BY/STARTS WITH can be brain-bending, too, if you are doing anything except the most straightforward use case. I found the "pseudocode" on this page under the "Interpreting connect by statements" header to be very enlightening: http://www.adp-gmbh.ch/ora/sql/connect_by.html http://www.adp-gmbh.ch/ora/sql/connect_by.html