Recursive Queries with 2 Variables and Select on Status

Handling Hierarchical Data with Recursive Subquery Factoring in Oracle Database

Dynamic Calculation using Oracle CASE Statements and Recursive Procedures: A Step-by-Step Solution

Plotting Hierarchically Indexing Pandas DataFrame: Solutions for the "None, None" Legend Entry

Oracle Hierarchy to Get All Children and All Parents of Each ID Using Recursive CTE