SYS_CONNECT_BY_PATH :
Syntax:
SYS_CONNECT_BY_PATH is a function which
is used in hierarchical queries to get the path for the current node starting
from Parent node.
SELECT SYS_CONNECT_BY_PATH ( column , char)
FROM table_name
START WITH <root_node>
CONNECt BY NOCYCLE PRIOR < child_node_col> = <Parent_node>
