Skip to Main Content

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!

SUM NVL

Olga12Dec 20 2012 — edited Dec 20 2012
Greetings,
I need to SUM columns of datatype VARCHAR2, and I get an error message "ORA-00909: invalid number of arguments". Is it possible to SUM these columns from ozf_claim_lines_all table?
sum(nvl (to_number(ocl.attribute3,0))+nvl (to_number(ocl.attribute5,0))+nvl (to_number(ocl.attribute7,0))+nvl (to_number(ocl.attribute9,0))+nvl (to_number(ocl.attribute11,0)))as"Total Adj Amount"
Thank you,
Olga
This post has been answered by stefan nebesnak on Dec 20 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2013
Added on Dec 20 2012
10 comments
1,021 views