All Products
Search
Document Center

Hierarchical query operators

Last Updated: Jun 18, 2021

The following table lists all hierarchical query operators.

Operator

Operand

Description

PRIOR

Unary

Indicates that the column is from the parent row.

CONNECT_BY_ROOT

Unary

Indicates the root ancestor.