Custom sorting and hierarchical queries

From: Rupesh Kapoor <rupesh_at_whowhere.com>
Date: 1997/02/12
Message-ID: <33021A13.67CD@whowhere.com>#1/1

Hi,

Is there a way in Oracle 7 to use a PL/SQL function for custom sorting instead of "ORDER BY ..."? On a related note, is there a workaround to the restriction that "ORDER BY" and hierarchical queries don't work together? I want to implement

select * from table1

	start with parent = NULL
	connect by prior myname = parent;

but would like the rows returned in pass 1 (parent = NULL) to be ordered by a column.

Thanks
Rupesh Received on Wed Feb 12 1997 - 00:00:00 CST