Re: SQL Puzzle

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • Date: Mon, 8 Feb 2010 14:02:57 -0800

On Mon, Feb 8, 2010 at 1:53 PM, Stephane Faroult <sfaroult@xxxxxxxxxxxx>wrote:

> RHAAAA ...
>   Why do you want some PL/SQL?

I don't want PL/SQL, I just can't figure out how to get what I want from

> Stuff the connect by (I don't expect
> 11GR2 yet :-)) into a subquery, add sys_connect_by_path to the select
> list of this subquery as ordering key, join and order by the ordering key.
> Should work.
Trying to stay in 9i if possible, but I will look sys_connect_by_path.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog:
Home Page:

Other related posts: