Database Administration (MOSC)

MOSC Banner

ORA-00979 with Hash Group by on 10.2.04

edited Jul 24, 2009 4:20AM in Database Administration (MOSC) 10 commentsAnswered
Hi All, I have one query which ran successfully on 9.2.0.8 and on 10g it is failing. Please help

Original Query:

SELECT dvm.dvm_sit_id, dvm.dvm_sec_id, dvm.dvm_payable_date,
                 dvm.dvm_ex_date, dvm.dvm_record_date,
                 dvm.dvm_income_value_date, dvm.dvm_dividend_type,
                 dvm.dvm_pct_amt, dvm.dvm_income_ccy, dvm.dvm_income_amt,
                 dvm.dvm_pool_factor
            FROM (SELECT   dvm.dvm_sit_id, dvm.dvm_sec_id,
                           dvm.dvm_payable_date, dvm.dvm_ex_date,
                           dvm.dvm_record_date, dvm.dvm_seq_no,
                           dvm.dvm_dividend_type,
                           MAX (dvm.dvm_dividend_status) dvm_dividend_status

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center