I require assistance with an Oracle SQL query
Record name is TREE. The two fields are PARENT & CHILD.
It's a tree structure i.e.
PARENT = 0001
CHILD = 2000
CHILD = 3000
PARENT = 2000
CHILD = 2500
I require an Oracle SQL statement stating that parent1 = 0001 and children = 2000 & 3000. Another level indicates - parent2 2000 & child = 2500.
I hope you help me with the SQL query.