Oracle Error ORA-30929: ORDER SIBLINGS BY clause not allowed here

Oracle Error Message

ORA-30929: ORDER SIBLINGS BY clause not allowed here

Reason for the Error

ORDER SIBLINGS BY clause is specifed in a query which doesn’t have CONNECT BY clause.

Solution

Remove ORDER SIBLINGS BY clause or add CONNECT BY clause.