Take HIERARCHY queries to a HIGHER LEVEL

Most of us have written the basic CONNECT BY query to traverse a hierarchy. But there is a LOT more power to hierarchy query processing that you might not know about.
Follow me!
blog: connor-mcdonald.com
twitter: / connor_mc_d
The Podcast!
podcasts.apple.com/au/podcast...
open.spotify.com/show/5dqVVft...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
Music: The Wine, The Cars, Ah! Montmartre! - Late Night Feeler
#sql #database

[@toomuchtube]

Nice one Connor. Like the GROUP BY clauses, there is a lot of functionality in Oracle SQL that has been available for quite a long time, but few seem to use it.
Pity, as performance, and output are enhanced by digging into the manuals and finding what functionality is available.

[@kevinzhang8974]

excellent video, simple and easy to understand!!! Thank you Connor!

[@DatabaseDude]

Glad you enjoyed it!