Home » SQL & PL/SQL » SQL & PL/SQL » what's the order of the return record from select
what's the order of the return record from select [message #9541] Tue, 18 November 2003 22:16 Go to next message
youbo
Messages: 1
Registered: November 2003
Junior Member
when I use select * from table without index,what is the record order?

Report message to a moderator

Re: what's the order of the return record from select [message #9544 is a reply to message #9541] Tue, 18 November 2003 23:38 Go to previous messageGo to next message
sujit
Messages: 94
Registered: April 2002
Member
No ordering as such. Preferably it is the way records are inserted (but not guaranteed). refer to http://asktom.oracke.com for details

Report message to a moderator

Re: what's the order of the return record from select [message #9546 is a reply to message #9541] Tue, 18 November 2003 23:48 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Like Sujit mentioned: there's no particular order. Since data is independent of its location, it can't be stored in a particular order.
If you want to sort the outcome, use ORDER BY.

btw, the website is http://asktom.oracle.com

MHE

Report message to a moderator

Re: what's the order of the return record from select [message #9555 is a reply to message #9541] Wed, 19 November 2003 05:31 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Unpredictable . See this -->

Report message to a moderator

Previous Topic: package compile with warning.
Next Topic: Count Records with value reference
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 18:37:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.