SQL> select comm,nvl(comm,0)from emp;
COMM NVL(COMM,0)
---------- -----------
0
300 300
500 500
0
1400 1400
0
0
0
0
0 0
0
COMM NVL(COMM,0)
---------- -----------
0
0
0
14 rows selected.
转载于:https://www.cnblogs.com/zhaoyangjian724/p/3798073.html