Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> 8i vs 9i: Difference in "group by" ?

8i vs 9i: Difference in "group by" ?

From: Andreas Koch <mail_at_kochandreas.com>
Date: Fri, 31 May 2002 20:32:26 +0200
Message-ID: <ad8fnv$6i8$06$1@news.t-online.com>


Hi,

is there some known difference in the group by directive between 9i and 8i?

We have an application that runs well on 7.3 to 8i. One customer tried it on a 9i, and it seems a statement like

select Decode(...about 3 lines of code...),foo from tblFoo
group by Decode(...about 3 lines of code...)

is GROUPED by the decode statement, but not ORDERED by it.  From our previous experiences GROUP allways caused an ORDER (unless overwritten with an explizit ORDER BY) - is this "unofficial" behaviour, or is the missing ordering a bug?

(well, we will probably use that chance to clean up that code a bit, using a view instead...)

-- 
                                                   Andreas
if ((sex==fem)&&(hobby==comp)&&(age~25)&&(status==single)
&&(cntry=GER)) goto http://www.kochandreas.com/home/single.htm
Received on Fri May 31 2002 - 13:32:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US