SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

connect by prior usage restricted to certain level in an hierarchy.

539790Jun 13 2007 — edited Jun 13 2007

Hi,
I had a requirement where the values are stored in a hierarchial basis in a database table. The hierarchy is upto five levels. When I use connect by prior, its using all the five levels to evaluate. But I want to restrict the evaluation upto only three levels. So can anyone help me out in resolving the issue. I would like to know how we restrict, the usage to only say, two or three levels.

Any help is highly appreciated.

Thanks and Regards,
Venky.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2007

Added on Jun 13 2007

5 comments

682 views