Re: Ordering CONNECT BY PRIOR output

not directly.
You can make a temporary table (*cringe*) that collects the output of the query, then select from that in the order you want.

I've also heard that you can index on the text you want to order by, and if you somehow can write your query so that it uses this index, (without necessarily using order by) then it will come back in this order... ( I never tried this one ).

hope it helps
Randy :)

Dave Macpherson (dave_at_fifthd.ca) wrote:
: Is it possible to sequentially order the results returned from a
: CONNECT BY PRIOR query such that the items returned at the SAME level
: are ordered alphabetically? I can't figure out how to do this.
 

: Thanks for any help.
 

: Dave Macpherson

--
    ..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