LEVEL

Purpose

This function returns for CONNECT BY queries the level of a node within the tree. For more information, refer to the SELECT statement in Query Language (DQL) section.

Syntax

level::=

Level

Example

SELECT last_name,
       LEVEL,
       SYS_CONNECT_BY_PATH(last_name, '/') "PATH"
   FROM employees
   CONNECT BY PRIOR employee_id = manager_id
   START WITH last_name = 'Clark';