Found Difference between 9i & 10g order by result
523923Oct 20 2009 — edited Oct 21 2009Hello Guru's
I have created following table in both 9i and 10g
test1 with Columns as below
A VARCHAR2(10)
B NUMBER
Inserted 2 records in 9i and 10g ( same data)
*9i Result:*
SELECT * FROM test1;
A B
-- --
2 1
2 2
*10g result:*
SELECT * FROM test1;
A B
-- --
2 1
2 2
But if I use order by clause getting different result.
*9i Result:*
SELECT * FROM test1 order by a;
A B
-- --
2 1
2 2
*10g result:*
SQL> select * from test1 order by a;
A B
-- --
2 2
2 1
Please help about this output mismatch for same query in 9i and 10g.
Thanks In Advance.
Sandeep.