All Products
Search
Document Center

Hierarchical query operators

Last Updated: Jan 04, 2020

The following table lists all hierarchical query operators.

Operator Operand Description
PRIOR Unary Indicates that the column is from parent row.
CONNECT_BY_ROOT Unary Indicates the top ancestor at the root.