Oracle 替换列中null值
Oracle 替换列中null值
Oracle 替换列中null值,替换scott表中comm列 用0代替null
select empno,(case when comm is null then 0 else comm end ) as comm from scott.emp;
Oracle 替换列中null值,替换scott表中comm列 用0代替null
select empno,(case when comm is null then 0 else comm end ) as comm from scott.emp;
评论暂时关闭