Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    59

    Unanswered: hierarchical trees

    Hi all and thanx in advance...

    There is a command in Oracle which is "connect by prior" and i think it's a function to build "hierarchical trees", so where can I find the source of this function, or if anybody knows it please tell me...

    What i mean is there would be an SQL function before "connect by prior" function written...

    Example... I can write a function called called sub

    function sub(x,y)
    {
    Z= X - Y
    return z
    }

    So and then in my program i can use z=sub(5,3) instead of z=5-3, i think connect by prior is same thing but of course longer coding.....
    Where can i get this code?

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    Next MSSQLSERVER version will have ANSI resursive join implemented (maybe).
    See http://www.experts-exchange.com/Data..._20514065.html
    for hints and resources where to start.

    Good luck !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •