Use parentheses () to specify the order of execution for the operators : Arithmetic operator « Introduction « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Introduction
  3. Arithmetic operator
SQL>
SQL> SELECT 10 * (12 / 3 - 1) FROM dual;

10*(12/3-1)
-----------
         30

SQL>








1.2.Arithmetic operator
1.2.1.The normal rules of arithmetic operator precedence apply in SQL
1.2.2.Use parentheses () to specify the order of execution for the operators