Sort the Childs under Parents in Oracle Hierarchial Queries using siblings

By Santhosh N

This explains how to sort the child records under the parent records by using order siblings by clause

SELECT firstname, lastname, employeeid, managerid
      FROM emp
      START WITH employeeid = 100
      CONNECT BY PRIOR employeeid = managerid
      ORDER SIBLINGS BY firstname;

Here, all the child records will be sorted under the individual parents.

Related FAQs

This explains how to trim the character(s) specified on the right hand side of the string
This explains how to pad the specified number of character(s) on the left side of the string to return specified character length string in oracle
This explains how to trim the character(s) specified on the either side of the string
Sort the Childs under Parents in Oracle Hierarchial Queries using siblings  (1303 Views)