Home » RDBMS Server » Server Administration » Not able to get data in ascending in Oracle10g (Oracle8.0.4.0 Unix true64 to Oracle10.2.0.2.0 in HP-UX11.23)
icon8.gif  Not able to get data in ascending in Oracle10g [message #396016] Fri, 03 April 2009 09:31 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear Sir,

I migrated a Oracle8.0.4.0 on OS Unix true64 to Oracle10.2.0.2.0 on OS HP-UX11.23.There is primary key on two column. At the time of select statement its not coming ascending order in Oracle10g.
I uploaded excel for reference.

Regards,
Sanjay

[Updated on: Fri, 03 April 2009 10:37] by Moderator

Report message to a moderator

Re: Not able to get data in ascending in Oracle10g [message #396019 is a reply to message #396016] Fri, 03 April 2009 09:32 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
do not cross/multi-post

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Re: Not able to get data in ascending in Oracle10g [message #396020 is a reply to message #396019] Fri, 03 April 2009 09:33 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
If you want the data ordered us an "order by".

Having an primary key or not has nothing to do whatsoever with the order of the returned data.
Previous Topic: Sequence giving me ora-00001 ? (unique constraint violated)
Next Topic: Use 10g to undo/check data from history
Goto Forum:
  


Current Time: Mon Dec 05 10:42:31 CST 2016

Total time taken to generate the page: 0.05902 seconds