HIERARCHICAL QUERIES

HIERARCHICAL QUERIES

If any table contains hierarchical data then we can select hierarchical rows by using hierarchical queries.

Syntax of Hierarchical queries:

SELECT LEVEL, COLUMN, EXPRESSION..
FROM TABLE
[WHERE CONDITION(S)]
[START WITH CONDITION(S)]
[CONNECT BY PRIOR CONDITION(S)]