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
SQL.
> 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: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
