Hi,
I am very confused to know the behavior of clauses action in different versions of oracle database.This is one of the example,I am going to show you which I had made and results are different on 9i and 10g-
SELECT 1 element, '1' value FROM dual
UNION ALL
SELECT 1 element, '2' value FROM dual
UNION ALL
SELECT 1 element, '3' value FROM dual
ORDER BY element;
Results are as follows:
[On 9i ]
1 1
1 2
1 3
[On 10g ]
1 1
1 3
1 2
Why and what the procedure both versions follows .
Bookmarks