Skip to Main Content
Forums

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 for column char

Rosario VigilanteFeb 24 2010 — edited Feb 24 2010
Hello

I have this sample 
IMP_RIC 
000020.50
000020.50
000020.50
000001.55
000020.50
000020.50

stored in a char column datatype

when I do 

SELECT COUNT(*) , SUM(TO_NUMBER (IMP_RIC ) /100) 
INTO N_RICETTE    , NETTO_ASL
FROM TRC_AMB_SAN;
I get error ORA-01722: invalid number

should I decode point to comma before running the query

thanks for any help
This post has been answered by 730428 on Feb 24 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2010
Added on Feb 24 2010
14 comments
2,497 views