Print and output values : Output Print « PL SQL « Oracle PL / SQL






Print and output values

SQL>
SQL> --The basic four arithmetic operators in action.
SQL> SET SERVEROUTPUT ON
SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE(4 * 2);  --Multiplication
  3     DBMS_OUTPUT.PUT_LINE(24 / 3); --Division
  4     DBMS_OUTPUT.PUT_LINE(4 + 4);  --Addition
  5     DBMS_OUTPUT.PUT_LINE(16 - 8); --Subtraction
  6  END;
  7  /
8
8
8
8

PL/SQL procedure successfully completed.

SQL>

           
       








Related examples in the same category

1.Concate values before output