How to sum formated numeric values [message #303653] |
Sat, 01 March 2008 11:47  |
dr.s.raghunathan
Messages: 540 Registered: February 2008
|
Senior Member |
|
|
hi,
Table Name Chk_cal
id number primary key
col_a varchar2(10)
col_b varchar2(10)
The following values are stored
Col_a Col_b
raju 12,765.12
kumar 34,567.12
I just want sum col_b and store it in memory variable
I tried
select sum(to_number(col_b)) into mem_vari from chk_cal;
Error has come as wrong numeric identifier
Any one can help me without disturbing the formated number
yours
dr.s.raghunathan
|
|
|
|
|