469,358 Members | 1,642 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,358 developers. It's quick & easy.

Hierarchy without "connect by prior"

3
Hi,

How can I run a query to fetch the hierarchy without using the command - connect by prior?
I want to use this query by BO, which does not support the connect byqstart with option.
thanks
Aug 6 '07 #1
4 4058
debasisdas
8,127 Expert 4TB
U can get the same out put by using JOIN ,but it will be slower in comparision to CONNECT BY PRIOR.
Aug 6 '07 #2
Adisc
3
U can get the same out put by using JOIN ,but it will be slower in comparision to CONNECT BY PRIOR.
for using join - I should know how many levels I have.
for example -
if my table holds:
son parent level
35 0 0
36 35 1
37 35 1
40 36 2
43 40 3
44 40 3
48 43 4

I would like to get 0, 35, 36, 40, 43, 48
Aug 6 '07 #3
debasisdas
8,127 Expert 4TB
You need to write self join for the purpose.
Aug 6 '07 #4
Adisc
3
can you please give me more details

thanks
Aug 6 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Hunter | last post: by
2 posts views Thread by Prakash Wadhwani | last post: by
1 post views Thread by delset | last post: by
3 posts views Thread by cberthu | last post: by
12 posts views Thread by Jonathan Wood | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.