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;
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 Question | Next Question |
Give the Types of modules in a form? | What is difference b/w stored procedures and application procedures, stored function and application function? |