ORA-01722:无效数字

Oracle/PLSQL

SQL:

SELECT NVL(SUM(A.AAB001), 0) BZC140, NVL(SUM(B.BCB004), 0) BZC141
FROM CC95 A, CC96 B
WHERE A.AAB001 = B.AAB001;

执行SQL语句的时候就提示：ORA-01722:无效数字.

最后发现cc95表中的aab001字段类型为VARCHAR(如下图所示),所以导致SQL语句执行异常 .

然后自己查了一下VARCHAR类型的字段怎么去统计数目.查到用count()函数.

最终SQL:

SELECT NVL(COUNT(A.AAB001), 0) BZC140, NVL(SUM(B.BCB004), 0) BZC141
FROM CC95 A, CC96 B
WHERE A.AAB001 = B.AAB001;