Oracle PL-SQL Question:
Download Questions PDF

How to order siblings in oracle hierarchy queries?

Answer:

SELECT last_name, employee_id, manager_id, LEVEL
FROM employees
START WITH employee_id = 100
CONNECT BY PRIOR employee_id = manager_id
ORDER SIBLINGS BY last_name;

Download Oracle PL-SQL Interview Questions And Answers PDF

Previous QuestionNext Question
Give the Types of modules in a form?What is difference b/w stored procedures and application procedures, stored function and application function?