Rollup( )函数总计行怎么用字符代替空格

Question

代码是
SELECT DEPTNO,JOB ,SUM(SAL)
FROM EMP
GROUP BY ROLLUP(DEPTNO,JOB );
怎么用字符“ALL JOB”代替job列的NULL值？

Answer 1

SELECT DEPTNO,nvl(JOB,'ALL JOB') job ,SUM(SAL)
FROM EMP
GROUP BY ROLLUP(DEPTNO,JOB );