SQL hierarchies using CONNECT BY and recursive WITH

[@drodsou]

Amazing, decades using SQL and never heard of this :-D. Thanks!

[@omarmorales909]

I been looking for an easy explanation on this subject and finally found your video! Thanks for sharing this, it has helped me to resolve a really big issue here at the manufacturing plant where I work. Thanks again!

[@njwarnock]

Absolutely excellent tutorial - thanks so much!

[@siddhartharao8490]

Great thanks for explaining the concept Precisely.

[@snaidu70]

Thank you Chris for this awesome explanation

[@albertogonzalez5114]

Thanks so much for this useful and enlightening explanation

[@praveenkumar-rk3hp]

Thank you Chris, This was very helpful But both connect by & recursive with are running for so long time (more than 1 hr) for data set of around 7M Can you please provide me any alternate

[@Pragya1819]

Hi... I'm having a BOM components under which many assembly n sub assembly are there.. I have transferred some of the assembly to manufacturing now, I need to fetch the which all assemblies are left (showing all child grandchild ) in oracle.. Plz help.. It's urgent

[@CaboLabsHealthInformatics]

are these clauses standard or Oracle only?

[@iftikhar8508]

How to retrieve a tree in forest like what if there are multiple hierarchies? for example a table with data about countries and their president, prime minister and ministers. Here every country will have its own Hierarchy and hence more than one base cases.

[@cesarcastillo2643]

in Oracle I tried both and I cannot pass from the first level down. I used the same recursive statement in sql lite and works as expected.

[@nadinfridburg7088]

Thank you!!!!!!!

[@jayashri_since2001]

Thankyou

[@SharjeelTahir-zq5ps]

bad mic