Re: SQL Puzzle
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: jkstill@xxxxxxxxx
- 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.
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@xxxxxxxxx
> <mailto:jkstill@xxxxxxxxx>> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
