Ordering branches in a connect by

I have a query using a connect by/start with. I don't own the table so I can't create any obects against it (index, trigger, etc) but I can create functions/procedures/packages that reference it.

What I need to do is sort the branches alphabetically. This is an example of the data returned:

   Controller's Office

             Grant Contract Fin Admin
             Capital Projects Accounting
             Financial Reporting
   Business Mgnt Board
            Project X
   Student F&A Services
           Dining Halls

What I need is as follows:

   Business Mgnt Board

            Project X
   Controller's Office

             Capital Projects Accounting
             Financial Reporting
             Grant Contract Fin Admin
   Student F&A Services
           Dining Halls

It's also more than 1 level deep. It can go as far as 7 levels and it's possible that in the future it'll go deeper.

Does anyone have any idea how to go about doing this? Order by of course overrides the connect by.

Thanks in advance,

Lewis

lewis.cunningham_at_yale.edu Received on Mon Sep 22 1997 - 00:00:00 CDT