Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


getPath of node OT

getPath of node OT

getPath of node OT

Hi team,

Could you indicate me the methods to get the full path of the required nodes in OT?

Thanks in advance.

RE: getPath of node OT

I use this:

FROM dtree
START WITH dataid = xxxxxxxx
CONNECT BY PRIOR dataid = parentid

RE: getPath of node OT

Just a mention the "Connect By" is a Oracle specific tree walk algorithm. SQLserver does not have it.That is the reason why OT has built DtreeAncestors and DBrowseAncestrors
to go through bread crumbing/.In SQLserver LL installation everyone has a favorite getLLPath function that emulates the "connect by" by what is the SQLserver equivalent called a CTE.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close