oracle

select nvl(字段名,0) from 表名;

-----------------------------------

sqlserver

select isnull(字段名,0) from 表名;