Archive for the ‘CONNECT_BY_ROOT’ tag
Down, up, and around Hierarchical Queries
Hierarchical queries are powerful structures in the Oracle database. They let you walk a tree down or up, but they can die when you fail to connect rows correctly. I’ve put together a Hierarchical Query Basics page. Hopefully somebody finds it useful.
Subscribe via RSS