Sorting the result using order by clause:order by clause is used to sort the data fetched using select statement either in ascending order or in descending. by default data fetched is sorted in ...

Developers can use the ORDER SIBLINGS BY feature of Oracle 10g and later to sort the records in a hierarchy created by the START WITH and CONNECT BY clauses in a SELECT statement.