Retrieving a path with SYS_CONNECT_BY_PATH v14
SYS_CONNECT_BY_PATH
is a function that works in a hierarchical query to retrieve the column values of a specified column that occur between the current node and the root node. The signature of the function is:
The function takes two arguments:
column
is the name of a column that resides in a table specified in the hierarchical query that's calling the function.delimiter
is thevarchar
value that separates each entry in the specified column.
This example returns a list of employee names and their managers. If the manager has a manager, that name is appended to the result.
In the result set:
- The
level
column displays the number of levels that the query returned. - The
ename
column displays the employee name. - The
managers
column contains the hierarchical list of managers.
The EDB Postgres Advanced Server implementation of SYS_CONNECT_BY_PATH
doesn't support use of:
SYS_CONNECT_BY_PATH
insideCONNECT_BY_PATH
SYS_CONNECT_BY_PATH
insideSYS_CONNECT_BY_PATH