Re: SQL Puzzle
Date: Mon, 08 Feb 2010 22:53:36 +0100
RHAAAA ... Why do you want some PL/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.
Jared Still wrote:
> On Fri, Feb 5, 2010 at 10:05 AM, Jared Still <jkstill_at_gmail.com
> <mailto:jkstill_at_gmail.com>> wrote:
> Well, a puzzle to me anyway.
> Someone here at work would like to be able to easily join to a
> table that contains an employee hierarchy.
> No takers?
> I guess it's PL/SQL time.
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Oracle Blog: http://jkstill.blogspot.com
> Home Page: http://jaredstill.com