Link Details

If a table contains hierarchical data, such as in an employee table, every employee has a remporting manager and every manager is an employee too and has all information the employee has, then you can select rows in a hierarchical order using the hierarchical query, for instance, you can use hierarchical query to find out all employees that report to Cathy (employee id is 101) directly or indiectly easily.