Monday, 9 September 2013

How to find all the children for a parent child relation on one table

How to find all the children for a parent child relation on one table

How will I find all the children under a folder? like in explorer you have
a folder under neeth you have folder + folder etc.
I am using ORACLE db.
Folder 1
|
Folder 2
| |
| Folder 3
| | |
| | Folder 7
| | |
| | Folder 8
| |
| Folder 4
|
Flder 5
|
Folder 6
This query gives me parent hierarchy.
SELECT AL_ITEM_ID, AL_FATHER_ID, AL_DESCRIPTION
FROM ALL_LISTS
CONNECT BY AL_ITEM_ID = PRIOR AL_FATHER_ID
start with AL_DESCRIPTION = '13.6'

No comments:

Post a Comment