Hierarchical functions

The following table describes the supported hierarchical functions.

Function Description
SYS_CONNECT_BY_PATH Returns the path of a column value from root to node in a hierarchical query. Column values are separated by char for each row returned by the CONNECT BY condition.