June 3rd, 2008, 10:30 AM
|
|
Guest
|
|
Posts: n/a
Time spent in forums:
Reputation Power:
|
|
|
Single query to find multi-level relationships?
>I was pleasantly surprised to find the CNNECT BY PRIR mechanism in PL/SQL which appears to do exactly what I want, although I am a little concerned about using vendor-specific SQL extensions. <<
It is actually a cursor in disguise. You can also try a recursive CTE,
but the performance will be pretty bad; it is procedural code in
disguise in the current implementations.
|
Web Development Archives Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
