SELECT without ORDER BY - LIFO or FIFO as result?
527448Aug 20 2006 — edited Aug 20 2006Friends, I have a Loop that it inserts in a table that does not possess indice. When I to apply one SELECT, the result will be always the same? This sequencia is important for me. SELECT without ORDER BY functions as a LIFO (stack - Last In, First Out) or FIFO (list/line - First In, First Out)?
Example:
declare
x number := 1;
Loop
exit when (x = 11);
insert into table1 (field1) values (x);
x: = x + 1;
end Loop;
When I will be to apply SELECT in the table ' table1 ' without ODER BY, which result that always will be returned?
I) 1, 2, 3, ..., 10?
or will be able to come in another order?
II) 10, ..., 3, 2, 1
thanks