Re: SQL Puzzle

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: