Re: recursive sql?# Database - 数据库
B*n
1 楼
For the second question, it's very easy with oracle.
Suppose you have a table like this:
SQL> select * from pt;
PARENT CHILD
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
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****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
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.
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)
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.
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.
相关阅读
How to display Chinese text (query results) properly on web ??oracle connection problemHow to Deploy EJB in Oracle Application Server?SQL求救,helpQuestion on relational calculusRe: 请问从哪里能找到有关多媒体数据库方面的资料？谢谢先！（内空）SQL*Loader的一个问题下学期选了一们数据库的课a complex sql query, high hand help!!!Re: How to display Chinese text (query results) properly on web ??ACCESS还是VB还是DHTML？Where can I download Pro*C/C++ precompiler? Thanks a lot!Question about Oracle Driverhelp!How to know which database I am connected?any informix high hand here? sql need help here.EXCEL问题求教？Special character in insert valuesdatabase evaluation网页中数据库格式显示问题