For the second question, it's very easy with oracle. Suppose you have a table like this: SQL> select * from pt; PARENT CHILD
b*e
2 楼
this is very cool! but oracle only right? where can I find more documentation about this connect by prior thing.. thanks
【在 B*****n 的大作中提到】 : For the second question, it's very easy with oracle. : Suppose you have a table like this: : SQL> select * from pt; : PARENT CHILD
a*i
3 楼
It only works in Oracle 8 , IIRC.
【在 b****e 的大作中提到】 : this is very cool! but oracle only right? where can I : find more documentation about this connect by prior thing.. : thanks
B*n
4 楼
you should be able to find more about hierachical query under subquery in Oralce 8i's SQL Reference.
【在 b****e 的大作中提到】 : this is very cool! but oracle only right? where can I : find more documentation about this connect by prior thing.. : thanks
b*e
5 楼
does this mean if i'm using ms sql or oracle 703 i'm basically hopeless? (i mean i can probably get the data out and process it in java or perl.. but probably no as efficient as doing it in db)
【在 B*****n 的大作中提到】 : you should be able to find more about : hierachical query under subquery in Oralce : 8i's SQL Reference.
B*n
6 楼
i just checked oracle 7.3 doc and hiearchical query was supported there... not sure about 703.
【在 b****e 的大作中提到】 : does this mean if i'm using ms sql or oracle 703 i'm basically : hopeless? (i mean i can probably get the data out and process : it in java or perl.. but probably no as efficient as doing it : in db)
b*e
7 楼
oh my typo.. i meant 7.3.3.1 :) right now not a problem for me since my client is using 8.0.. but just wondering what if my client used ms sql :)
【在 B*****n 的大作中提到】 : i just checked oracle 7.3 doc and hiearchical query was : supported there... not sure about 703.