[내장 함수] COALESCE

-- COALESCE : NULL이 아닌 첫번째 값 선택

select coalesce(null, null, 'A', 'B', 'C') from dual;

select ename, comm, mgr, sal, coalesce(comm, mgr, sal) from emp;