SQL Connect By

Utility to create the SQL Connect BY query for printing results in a hierarchical order.
Please enter TableName, Parent, Child Column names and press Submit button.

Step 1. TableName Step 2. Child ColumnName Step 3. Parent ColumnName Step 4. Press Button

  
Example: 
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;