摘要:NVL2
NVL2 (要判斷的欄位, 如果不是NULL 則取這裡, 如果是NULL則取這裡)
SELECT
employee_id,
commission_pct,
NVL2(commission_pct,'有佣金','無佣金') "佣金"
FROM employees
WHERE employee_id > 140;
REF:http://pclevin.blogspot.tw/2014/05/oracle-sql-nvl2-null.html
2014-10-02
NVL2
SELECT
employee_id,
commission_pct,
NVL2(commission_pct,'有佣金','無佣金') "佣金"
FROM employees
WHERE employee_id > 140;