Oracle PL/SQL - Improving Readability with Parentheses

Introduction

You can use parentheses to improve readability for long expressions.

The parentheses in the following code do not affect evaluation order.

Demo

SQL>
SQL> DECLARE--   w  ww. j av a  2  s.  c  om
  2    a INTEGER := 2**2*3**2;
  3    b INTEGER :=  (2**2)*(3**2);
  4  BEGIN
  5    DBMS_OUTPUT.PUT_LINE('a = ' || TO_CHAR(a));
  6    DBMS_OUTPUT.PUT_LINE('b = ' || TO_CHAR(b));
  7  END;
  8  /
a = 36
b = 36

PL/SQL procedure successfully completed.

SQL>

Related Topic