[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1973
  • Last Modified:

CONNECT BY PRIOR

Does UDB support the "CONNECT BY PRIOR" syntax for hierarchy select?
0
kalakhr
Asked:
kalakhr
1 Solution
 
BigSchmuhCommented:
Not to my knowledge (I mean I have only been through the v7 EEE on NT release of UDB) but it is easy to create a denormalized table managed by triggers.
0
 
jcelkoCommented:
No.  And you not ever use it.  It is proprietary, non-relational and slow.  

I have a book on TREES & HIERARCHIERS IN SQL coming out later this year which goes into detail about several different ways to do this in pure SQL.  

Google "nested Sets Model" for a start.


0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now