Hi, DBAs:



Does anybody know how to force "select distinct ...." and "group by "
to sort the result set when not use "order by" in Oracle 10g, the
results set is sorted in Oracle8i , but not get same sorted result set
in Oracle 10g using same SQL, We met this trouble when we migrate
database from 8i to 10g for a Production database. I tried NLS_LANG and
NLS_SORT environmental parameter, it doesn't work, any initial parameter
or environmental parameters we can use to force to sort for SELECT
distinct or group by?



I appreciate your input !



Thanks



Jim


Oracle LazyDBA home page