[thelist] [DB Design] Recursive Directory Structure

[rudy]

> Is there some way to do this easily w/ Oracle?

yes, the syntax is something like CONNECT BY ... START WITH ...

you indicate which column is the recursive key, and the value to start with,
and then stand back, watch out for the poppencorken mit spitzensparken
(http://www.planetmvs.com/overhead/achtung.html)

i cannot comment on performance, because i have never had the opportunity to
play with this syntax

it is one call to the database, though, so it's just gotta be faster than
calling for one record at a time in a loop

no offence to all you object oriented coders, you might produce simple and
slick recursive functions, but calling for one record at a time is slow


rudy