avatar
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
avatar
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

avatar
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

avatar
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

avatar
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.

avatar
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)

avatar
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.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。