Hierarchical SQL Queries: Databases for Developers #16

Often data contains a parent-child relationship between rows in the same table. For example, company org charts and family trees.

You can use the power of SQL to traverse these hierarchical relationships. There are two ways to do this in Oracle Database:

- Connect By
- Recursive With

Watch this video to learn about data trees and find out how these work!

Further reading:

============================
The Magic of SQL with Chris Saxon

Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

[edgards]

Fantastic video!! it's 8pm here at my office and I'm dancing because this function has helped me a lot.

[Samalbabu]

No where on web I found such helpful fundamental description on hierarchy..!! Thank you 😊

[phamucmanh]

So amazing ! Keep producing videos, please. Thank you !

[CalvinYio]

just made reading a while wall of text easier but is there any tutorial or exercise i can practise this with?

[shashankjain]

Great Video!, Helped me understand the concept .

[mario-t]

Thanks much, So this is for Oracle, I think something similar can be done on MS? (and without music-) Thanks much

[jallunick]

Where can I find the sql queries shown in this video?

[DavidLeiser]

What to do if you dont know the root? Can this be done in the same statement or should this be done in a seperate querry?

[bostonmacosx]

Ok...why in the recursive with do you have a "yf." there is no alias refereing to a yf table...

[aggreyafray]

hi just inquiry can i use those functions in mysql and php?

[AndiRadyKurniawan]

Is the hierachical query faster than the nested set model?

[jeandedieuntirampeba]

WHAT CAN I DO WITH MYSQL WHEN I WANT TO RESOLVE THE PROBLEM LIKE THAT?

[neeleshshah]

Oh.. to take care of divorces, re marriages, children from multiple marriages.. and… shocker.. marriages of cousins (at a broad 4th/5th level).. i had to patch up the data model.. !!

[samt]

The background music needs to be changed.

[wiktor]

"But, of course, in real life everyone has two parents" In 2022 is not so obvious...

[KirillBezzubkine]

Video s good but this damn stupid BG music is really distracting

[JustBCWi]

Thumbed down, misleading title. This is "Oracle Databases" for developers

[enockoloo]

too much illustration is distracting and annoying.