This discussion is archived
2 Replies Latest reply: Mar 22, 2013 12:16 AM by MuRam RSS

Reg: Ordering in 11g

Bhargav K Newbie
Currently Being Moderated
Hi Guys,

can any one clarify me..pls

i have a request having columns like Desc_Quarter,Currency and dollars
in both 10g and 11g.
i placed Desc_Quarter,Currency, dollars(calculated column) in both the reports..
but while i examine the Viewlog grouping is not happening like in 10g.
so the result for Dollars is not matching :(

SQL 10g:

select T148096.DESC_QTR as c2,
T148096.CURRENCY as c3,
T148096.SOLD_AMOUNT as c5,
T148096.AMOUNT_SUMMED as c6,

from
HR.DOLLARS_TABLE T148096
where ( T148096.ACTIVE = 'OPEN' and T148096.DATE_RATE = TO_DATE('2011-01-21 00:00:00' , 'YYYY-MM-DD HH24:MI:SS')


SQL 11g:

select T148096.CURRENCY as c2,
T148096.DESC_QTR as c3,
T148096.SOLD_AMOUNT as c5,
T148096.AMOUNT_SUMMED as c6,

from
HR.FOREX_REFINED_TABLE T148096
where ( T148096.ACTIVE = 'OPEN' and T148096.DATE_RATE = TO_DATE('2011-01-21 00:00:00' , 'YYYY-MM-DD HH24:MI:SS') order by c2, c3




NOTE: In the SQL of 11g , query is grouping by CURRENCY and then DESC_QTR.

why like this???

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points