Re: SQL Puzzle
From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Mon, 08 Feb 2010 22:53:36 +0100
Message-ID: <4B7087E0.5080505_at_roughsea.com>
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.
Date: Mon, 08 Feb 2010 22:53:36 +0100
Message-ID: <4B7087E0.5080505_at_roughsea.com>
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.
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 08 2010 - 15:53:36 CST