select level , PAGE_ID , PAGE_NAME ,PARENT_PAGE_ID
from DEMO_PAGE_HIERARCHY
start with PARENT_PAGE_ID is null
connect by prior PAGE_ID = PARENT_PAGE_ID
|
|
| 2 | 1 | Home | 0 |
| 2 | 8 | Admin | 0 |
| 2 | 5 | Charts : Cluster Bar | 0 |
| 2 | 4 | Orders | 0 |
| 2 | 3 | Products | 0 |
| 2 | 2 | Customers | 0 |
| 3 | 15 | About This Application | 1 |
| 3 | 7 | Add/Modify Customers | 2 |
| 3 | 6 | Add/Modify Products | 3 |
| 3 | 11 | Enter a Customer | 4 |
| 3 | 29 | View Order Details | 4 |
| 3 | 16 | Charts : Pie Chart | 5 |
| 3 | 17 | Charts : Stacked Bar | 5 |
| 4 | 10 | Add Product Image | 6 |
| 3 | 9 | Reset Password | 8 |
| 4 | 12 | Select Items | 11 |
| 5 | 14 | Order Confirmation | 12 |
| 1 | 0 | Sample Application | - |
|
|