OraFAQ Forum: Server Administration » Not able to get data in ascending in Oracle10g

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to get data in ascending in Oracle10g [message #396016]

Fri, 03 April 2009 09:31

kesavansundaram
Messages: 183
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

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: Not able to get data in ascending in Oracle10g [message #396020 is a reply to message #396019]

Fri, 03 April 2009 09:33

ThomasG
Messages: 3211
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.

Report message to a moderator

Previous Topic:	Sequence giving me ora-00001 ? (unique constraint violated)
Next Topic:	Use 10g to undo/check data from history

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 00:06:54 CDT 2024