Evaluate this SQL statement:
e.employee_id, (.15* e.salary) + (.5 * e.commission_pct)
+ (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE
FROM employees e, sales s
WHERE e.employee_id = s.emp_id;
What will happen if you remove all the parentheses from the calculation?
A.
The value displayed in the CALC_VALUE column will be higher.
B.
There will be no difference in the value displayed in the CALC_VALUE column.
C.
The value displayed in the CALC_VALUE column will be lower.
D.
An error will be reported.
Explanation:
There will be no difference in the value displayed in the CALC_VALUE column because not
arithmetic operations or usage of alias for the calculated expression in the SELECT clause will not
cause change the value appearance.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 29-34
Chapter 1: Overview of Oracle Databases