Oracle 10g R2 data sorting issue
The other day I imported the all of the schemas from our current Oracle 10.1.0.4 instance into a newly-created Oracle 10.2 instance. Now, when I query the new R2 instance, I'm noticing that the sort order for many of the numeric fields has been lost, as compared when querying the same fields in the 10.1.0.4 instance (with the data coming back as correctly sorted).
Have any of you noticed same / similar characteristics with the data in your R2 instances ?
Oracle 10.1.0.4 instance query and output :
SQL> select distinct T1."PROD_LINE" as c2,
2 T1."PROD_COST" as c4
3 from "IMPQC"."PRODUCT" T1
4 where (T1."PROD_LINE" = 'Back Packs');
C2 C4
-------------------- ----------
Back Packs 9
Back Packs 12
Back Packs 16
Back Packs 88
Oracle 10.2 instance query and output :
SQL> select T1."PROD_LINE" as c2,
2 T1."PROD_COST" as c4
3 from "IMPQC"."PRODUCT" T1
4 where (T1."PROD_LINE" = 'Back Packs');
C2 C4
-------------------- ----------
Back Packs 9
Back Packs 88
Back Packs 12
Back Packs 16
Am I missing something here completely ?? ... Thanks to any who can shed some light on this ...
TTYL,
Travis