Home » SQL & PL/SQL » SQL & PL/SQL » Oracle rows displays not in same order
Oracle rows displays not in same order [message #392827] Thu, 19 March 2009 07:45 Go to next message
jaisha
Messages: 1
Registered: March 2009
Junior Member
Hai All,

I've bunch of records and im updating the one column of the row. After updating the record when i select the records, order of the updated record has been changed. Im not using any order by in my query. For example i've 10 records and im updating one column of the 5th record. While selecting the records, updated record(5th) is now in 2nd position. Please suggest



Thanks in advance
Jai
Re: Oracle rows displays not in same order [message #392828 is a reply to message #392827] Thu, 19 March 2009 07:47 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
jaisha wrote on Thu, 19 March 2009 08:45
Im not using any order by in my query


It couldn't be any more clear than what you wrote yourself. How do you expect it to appear in any order?
Re: Oracle rows displays not in same order [message #402392 is a reply to message #392828] Sat, 09 May 2009 16:21 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
what order did you think you would get?

why?

Kevin
Previous Topic: close and re-open cursor for every 20 records
Next Topic: Multiple insert statement or One dynamic insert
Goto Forum:
  


Current Time: Wed Dec 07 16:13:55 CST 2016

Total time taken to generate the page: 0.10739 seconds