【单项选择题】
Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns:<br /> <img src="https://img.ppkao.com/2018-08/yiyu/2018080115005482258.jpg" /><br /> Which statement ensures that a value is displayed in the calculated columns for all employees?（）<p> Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns:<br /> <img src="https://img.ppkao.com/2018-08/yiyu/2018080115005482258.jpg" /><br /> Which statement ensures that a value is displayed in the calculated columns for all employees?（）</p>
A、A. SELECT last_name, 12*salary* commission_pct FROM emp;
B、B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C、C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D、D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
查看正确答案
