Re: Clause "ORDER BY" in a clause "CONNECT BY PRIOR"

This is a hack - but it might do what you need. create an index on the table in the order you want the columns sorted. This can provide the orderin you are looking for ( only one of the orderings though and always in that order ). otherwise - i've resorted to Pro*whatever code, and/or temorary tables to hold the result set then a select with the correct order.

good luck
Randy :)

comtech (comtech_at_mipnet.fr) wrote:

: I have a table with a hierarchy. I request ORACLE to
: give the tree with the clause "connect by prior".
: This feature is very exciting but has some limitations (example :
: not "connect by" in a view). An other limitation
: (referenced in Oracle'documentation) is that I can't
: sort the tree
: 1) by hierarchy
: 2) by a column
 

: I think it depends of the insert order in table.
 

: Example : Insert Order like this
 

: 1 -- 11 -- 112
: - 111
: 10 -- 101
 

: I want to retrieve in this order
 

: 1 -- 10 -- 101
: 11 -- 111
: 112
 

: but I have always the initial order !
 

: I know it's a hard problem but
: Is anybody can help me or give a way ?
 

: Laurent Fourny
: comtech_at_mipnet.fr
 

: Toulouse (FRANCE)

--
    ..uu.                                     ----------------------
  .?$" '?i     .                              I  Randy DeWoolfson  I
 .T^M  ._at_"    d9    .     f   ,.un.  b,    i  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``"# `M   _at_"  I  randyd_at_cais.com   I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I        ,\//.       I
    &  'M ,P    `E  M   "$  Mux~      n!`     I        |o o|       I
   dk   `h"       ' j     " y"       *~       I====oOO==(_)==Ooo===I