RE: SQL Brain Teaser Challenge

Hi Steve/Jared,
It was coincidence that just when Steve posted this we were trying to flatten the hierarchy and PL/SQL was the only option and I was doing some reserach and stumbled upon this parameter and then I used to it to generate output using the sys_connect_by_path and then all I had to do was parse the output and then populate the level columns based on that to get my complete hierarchy

You are right Jared, once you set the parameter, most of the things (except the siblings as its a new keyword only since 9i I think) start working as in 9i but with a undoc parameter.

Regards,
Madhavan
http://www.dpapps.com

On Thu, 07 Nov 2002 07:49:22 -0800, "Orr, Steve" <sorr_at_rightnow.com> said:
> Hey Jared, just got this because I was on a 4X10 day off yesterday.
> Anyway,
> thanks for the info. There was lots of great discussion on this and I
> appreciate the collective brain power of the list. Proposed solutions: 1)
> upgrade to Oracle 9i and use an inline view; 2) use a hint; 3) use
> indexes
> on the columns to be sorted; 4) use an undocumented parameter; 5)
> Metalink... No help yet.
>
>
> Steve Orr
> Bozeman, Montana
>
>
>

-- 
Madhavan Amruthur
DecisionPoint Applications

-- 
http://fastmail.fm - The way an email service should be
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Madhavan Amruthur
  INET: mad5698_at_fastmail.fm

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).