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 (1361 Views)