Oracle NEVER guarantees any ordering without an ORRDER BY; therefore,
your developers have created an enormous BUG by relying on this
sorted subset of data without specifying an ORDER BY.



Hans

-----Original Message-----
From: Shi Jim - Workstream
[mailto:oracledba-ezmlmshield-x70478728.[Email address protected]
Sent: woensdag 27 september 2006 20:23
To: LazyDBA Discussion
Subject: 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
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


Oracle LazyDBA home page