NVL2

2014-10-02

摘要: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