Interval value expressions : 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     A INTERVAL YEAR TO MONTH;
  3     B INTERVAL YEAR TO MONTH;
  4     C INTERVAL DAY TO SECOND;
  5     D INTERVAL DAY TO SECOND;
  6  BEGIN
  7     A := INTERVAL '40-3' YEAR TO MONTH;
  8     B := INTERVAL '40' YEAR;
  9
 10  END;
 11  /

PL/SQL procedure successfully completed.

SQL>