Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Exclamation Unanswered: ordering hierarchical select

    hi guys,

    i made a tree of messages by hierarchical select. i want to order items in each node of tree (by create date or subject). how can i do it?

    thanx for answer
    jimi

  2. #2
    Join Date
    Nov 2003
    Posts
    2

    solution...

    ...i solved this problem, so here is it:

    SELECT col1, col2
    FROM table
    WHERE where_condition
    START WITH start_with
    CONNECT BY PRIOR connect_by_prior
    ORDER SIBLINGS BY order_col;

    (tested under oracle 9.2.0.1.0)

Posting Permissions

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