Archive for the ‘hierarchical queries’ tag
San Francisco is nice, but Idaho and Wyoming are great!
San Francisco was nice as always but I thought a quick view of the natural beauty of Idaho and Wyoming would be nice to share. I took this during our lunch break at a faculty meeting. The valley in the distance is the northern edge of Star Valley in Wyoming.
I also wanted to let you know that I replaced the text returns from hierarchical queries with screen shots. I think they better illustrate how you navigate trees in recursive tables. You’ll find them in the Hierarchical Queries Basics page if you’re interested.
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