All Products
Search
Document Center

Hierarchical query operators

Last Updated: Dec 31, 2019

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.