再套一层查询: select nvl( (select null from dual),0) from dual 类似的技巧 还有查询的字段如何相乘 例如: select sum(age*number) as res from table