B*****n
发帖数: 135 | 1 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
发帖数: 1275 | 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
发帖数: 4391 | 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
发帖数: 135 | 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
发帖数: 1275 | 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
发帖数: 135 | 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
发帖数: 1275 | 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.
|
