DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: This SQL is for hierarchical Trees but I dont understand it

Hybrid View

  1. #1
    Join Date
    Aug 2003
    Posts
    9

    Unhappy This SQL is for hierarchical Trees but I dont understand it

    This SQL is for hierarchical Trees but I dont understand it.
    Its ont the oracle university book.

    select 1, level, ename, NULL, to_char(empno)
    from emp
    connect by prior empno = mgr
    start with job =''PRESIDENT''


    I dont understand why select 1,
    AND I also dont understand the last 2 lines. connect by prior and start with??
    thanks
    add me to your messenger

    perrohijueputa@hotmail.com

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    Cheers!
    OraKid.

  3. #3
    Join Date
    Aug 2003
    Posts
    9
    Sorry. This page does not exist.
    The URL you requested could not be found on this server. Please check the spelling in the URL or use our search to find what your are looking for. Thank you
    add me to your messenger

    perrohijueputa@hotmail.com

  4. #4
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

Posting Permissions

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


Click Here to Expand Forum to Full Width