getPath of node OT

[coreel91]

Hi team,

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

Thanks in advance.
Regards.

 

[appnair]

?

What does this mean?

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

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[CherylAnderton]

I use this:

SELECT SYS_CONNECT_BY_PATH (name, '/') FULL_PATH
FROM dtree
START WITH dataid = xxxxxxxx
CONNECT BY PRIOR dataid = parentid

 

[appnair]

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

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in