Hierarchy without "connect by prior"

[Adisc]

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

[debasisdas]

U can get the same out put by using JOIN ,but it will be slower in comparision to CONNECT BY PRIOR.

[Adisc]

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

[debasisdas]

You need to write self join for the purpose.

[Adisc]

can you please give me more details

thanks