This forum is currently locked. You can't register or post questions at this time. (read more)

Oracle parentChild query

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Guest

Oracle parentChild query

Postby Guest » Mon Nov 01, 2004 6:09 pm

Gurus,

I need help to figure out a query which will result to get parent child relation for ranges of data

eg:
Name Low High
t1 10000 20000
t2 10000 20001
t3 11000 15000
t4 10500 19000
t5 11000 14500


Results
Name Parent Low High
T2 0 10000 20001
t1 t2 10000 20000
t3 t1 11000 15000
t4 t1 10500 19000
t5 t3 11000 15000


Child will have only one parent

please help

gbk

Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 4 guests

cron