oracle 替换列中null值

1.替换scott表中comm列 用0代替null

select empno,(case when comm is null then 0 else comm end ) as comm  from scott.emp;