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