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

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) Received on Tue Apr 16 1996 - 00:00:00 CEST