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: 65143
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: 65143
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: 8737
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: commit inside a trigger (merged 3)
Next Topic: how to fix ORA-00904 Error
Goto Forum:
  


Current Time: Sat Aug 19 02:36:08 CDT 2017

Total time taken to generate the page: 0.13874 seconds