Interval multiplication : INTERVAL « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. INTERVAL

SQL>
SQL> DECLARE
  2     a1 INTERVAL DAY TO SECOND := '2 3:4:5.6';
  3     a2 INTERVAL YEAR TO MONTH := '2-10';
  4     a3 NUMBER := 3;
  5  BEGIN
  6
  7     DBMS_OUTPUT.PUT_LINE(a1 * 2);
  8     DBMS_OUTPUT.PUT_LINE(a2 * 2);
  9     DBMS_OUTPUT.PUT_LINE(a3 * 2);
 10
 11  END;
 12  /

PL/SQL procedure successfully completed.

SQL>
SQL>