Home » SQL & PL/SQL » SQL & PL/SQL » how to emulate "order siblings by" in 8i? (8i)
how to emulate "order siblings by" in 8i? [message #364622] Tue, 09 December 2008 05:47 Go to next message
kang
Messages: 89
Registered: November 2007
Member

As you know "order siblings by" was introduced in oracle 9i,
how can I emulate "order siblings by" in oracle 8i?

Thanks.
Re: how to emulate "order siblings by" in 8i? [message #364624 is a reply to message #364622] Tue, 09 December 2008 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is very hard, you may (sometimes) get it with a proper index as a side effect of access path.

Regards
Michel

[Updated on: Tue, 09 December 2008 06:01]

Report message to a moderator

Re: how to emulate "order siblings by" in 8i? [message #364627 is a reply to message #364622] Tue, 09 December 2008 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the following thread in AskTom: ordering a connect by

Regards
Michel
Re: how to emulate "order siblings by" in 8i? [message #364710 is a reply to message #364627] Tue, 09 December 2008 13:58 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8635
Registered: November 2002
Location: California, USA
Senior Member
http://www.orafaq.com/forum/m/26708/0/#msg_26708

[Updated on: Tue, 09 December 2008 14:02]

Report message to a moderator

Re: how to emulate "order siblings by" in 8i? [message #375789 is a reply to message #364710] Sun, 14 December 2008 13:04 Go to previous message
kang
Messages: 89
Registered: November 2007
Member
great!
Previous Topic: What is the best way of forming a query?
Next Topic: forum thread like query using connect by...
Goto Forum:
  


Current Time: Thu Dec 08 16:21:46 CST 2016

Total time taken to generate the page: 0.06684 seconds