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.
相关阅读
【紧急求助】SQL数据导出Oracle在中国金融行业ERP成功验收报告数为零(ZZ)mysql里可以count多个区间吗一个SUN公司certificate的deal兼问MySQL DBA certificate有用吗？谁给比较一下PostgreSQL和mysql好多工作都说最好懂数据库，怎么先补啊Help on Oracle QueryHow to design the sql for this problem?哪位试过在win 7上装sybase ase 15？Cassandra @ Twitter: An Interview with Ryan King (ZZ Link only)请问mysql这个语句如何写？菜鸟求助: 用 Oracle Sqlldr Control File 能不能改character set?log shipping 问题mysql mapping and insert questionSQL injection attack claims 132,000+(ZZ)学会SQL自然就会mySQL吗？哪儿有9.2.0.7patch下载?菜鸟求助: 用 Oracle Sqlldr Control File 能不能改character set?sql server 问题菜鸟求助: 用 Oracle Sqlldr Control File 能不能改character set?