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
Copy
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';