Skip Headers

# Hierarchical Queries

Previous

Next

Oracle database Hierarchical Queries mechanism lets you select database rows based on hierarchical order. For example, you can design a query that reads the row of a given employee, followed by the rows of people the employee manages, followed by their managed employees, and so on.

You specify a hierarchical query clause using `DatabaseQuery` subclass `ReadAllQuery` method `setHierarchicalQueryClause`. For more information on `DatabaseQuery` queries, see "Database Queries".

For more information on configuring a `ReadAllQuery` with an Oracle hierarchical query clause, see "Hierarchical Queries".