Have you ever been faced with a hierarchical data tree where you need to get a specific path or make a validation before adding/editing a node? In this post, we’ll show you how to do that by using CTEs / CONNECT BY on advanced queries on SQL and Oracle.