sys_connect_by_path « Hierarchical Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Hierarchical Query
  3. sys_connect_by_path
1.sys_connect_by_path(lastname, '/')
2.lpad(' ',2*level-2) || sys_connect_by_path(lastname, '/')
3.sys_connect_by_path function will take any column
4.sys_connect_by_path function
5.sys_connect_by_path demo
6.sys_connect_by_path in hierarchical query