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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
