2 Replies Latest reply: Mar 22, 2013 2:16 AM by MuRam RSS

    Reg: Ordering in 11g

    Bhargav K
      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???