SYS_CONNECT_BY_PATH
Purpose
For a CONNECT BY
query, this function returns a string containing the full path from the root node to the current node, containing the values for expr
and separated by char
. For more information, refer to the SELECT statement in Query language (DQL) section.
Syntax
sys_connect_by_path::=
Example
SELECT SYS_CONNECT_BY_PATH(last_name, '/') "PATH"
FROM employees
WHERE last_name = 'Johnson'
CONNECT BY PRIOR employee_id = manager_id
START WITH last_name = 'Clark';