Calculating the sum of varchar2 data fields in Oracle 10g
How to use the sum function of SQL to calculate sum of var开发者_如何转开发char field. I'm looking for a solution where we cannot use count.
If the varchar field contains strings that can be interpreted as numbers:
select sum(to_number(the_column)) from the_table
If not, I do not understand the question.
精彩评论