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





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