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