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
smime.p7s
Description: application/pkcs7-signature
