I repeat another response to this. Without an ORDER BY, you are NEVER
guaranteed an ordering.


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------





"Shi Jim -
Workstream "
<oracledba-ezmlms To
hield-x70478728.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

09/27/2006 02:22 Subject
PM select distinct trouble (urgent)










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



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page