Re: will the Return Order of rows change with time ?

Hi

Without a order claus on the statement there is no granti of the order the rowes are rurned.
This is not specific to Oracle but part of the sql standard.

Ratnesh Kumar Singh wrote:

>Hi
>
>I have a very large DW table in which there are only inserts and NO
>updates/deletes.
>The table grows by around 2-5 % every week due to new inserts.
>
>I need to return the rows for each customer in the same order as inserted to
>table.
>Due to design/delivery constraints , i cannot modify the table.
>
>ques 1 : if i do a 'select * from table' with where clause but no order by
>clause,
> will the Order of rows returned be the same whenever this query is
>executed ?
> Is this gauranteed by Oracle ?
>
>ques 2 : if i export/import this table , then execute the same query,
> will the Order of rows returned be the same as before the export/import
>?
>
>ques 3 : if i use the 'move' cmd to rebuild this table , then execute my
>query,
> will the Order of rows returned be the same as before the rebuild ?
>
>any explanations are most welcome....
>
>many thanks
>ratnesh singh
>
>-------------------------------------------------
>Ratnesh Kumar Singh
>Sr. Software Engineer
>Patni Computer Systems Ltd
>TTC Mahape , Navi Mumbai
>Work : (91 22) 7611090/110/128/350 Ext. 2107/2106
>Home : (91 22) 8662162
>http://www.patni.com
>World-Wide Partnerships. World-Class Solutions.
>-------------------------------------------------
>
>
>

-- 
Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856
mailto:peter.gram@MiracleAS.dk - http://MiracleAS.dk





Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.

--------------ms070608000003030301080501--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



application/x-pkcs7-signature attachment: smime.p7s