17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> select nvl(null,null,1) from dual;
select nvl(null,null,1) from dual
ORA-00909: invalid number of arguments
select decode(字段1,null,1,0)+....+decode(字段n,null,1,0)
from table
where ....;
select decode(字段1,null,1,0)+....+decode(字段n,null,1,0) from table;