Re: how to order a 'branch' in a CONNECT BY query
From: Hank Robinson <cudau_at_csv.warwick.ac.uk>
Date: 20 Aug 1994 14:41:59 +0100
Message-ID: <335177$oq4_at_crocus.csv.warwick.ac.uk>
Date: 20 Aug 1994 14:41:59 +0100
Message-ID: <335177$oq4_at_crocus.csv.warwick.ac.uk>
dmcohen_at_eng.umd.edu (Daniel M. Cohen) writes:
> How do you order a 'branch' when using SQL's connect by clause? I
> tried to add the 'order by' clause but this order the entire query,
> not just each subset ('branch') of the rows.
You can't (to the best of my knowledge); I've also tried in the past; I even got Oracle Support trying it, and they, too, said it couldn't be done; you need to use a view.
> Regards, Henry
Hank Robinson
Oracle DBA
University of Warwick
Received on Sat Aug 20 1994 - 15:41:59 CEST