You should have NEVER assumed that your GROUP BY would automatically return
things in sorted order. That it did, in most cases, was a by-product of
how the grouping
mechanism in the Oracle server was implemented, but Oracle itself has
ALWAYS said
to include an ORDER BY if a sort was desired.
Nothing got "broken" in the GROUP BY in going from 9i to 10g.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
"Calvin Shafer "
<oracledba-ezmlms
hield-x25787091.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
03/05/2007 02:45
PM Subject
RE: Upgrade experiences from 9i to
10gR2
I hear that GROUP BY no longer does an assumed ORDER BY, you must add them
to your SQL.
-----Original Message-----
From: ron [mailto:oracledba-ezmlmshield-x65794550.[Email address protected]
Sent: Monday, March 05, 2007 2:38 PM
To: LazyDBA Discussion
Subject: Upgrade experiences from 9i to 10gR2
We have one guy who is saying he had to change SQL and PL/SQL to get 10g
working. I don't believe him.
Can anyone relate experiences with apps? How difficult was it to get
applications working with 10gR2? Any compatibilty issues?
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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