SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

invalid number of arguments

724220May 10 2012 — edited May 10 2012

SELECT ID
, sum(round(ceil(MONTHS_BETWEEN(nvl(DT1,(add_months(last_day(trunc(sysdate)), -1)) )), DT2)), 2)*10) paid
FROM tabel1
GROUP BY ID

error message:ORA-00909: invalid number of arguments
00909. 00000 - "invalid number of arguments"

Can someone help me with this query.

regards

This post has been answered by Solomon Yakobson on May 10 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2012

Added on May 10 2012

3 comments

1,844 views