length of service for INTERVAL YEAR TO MONTH : 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     start_date DATE;
  3     end_date DATE;
  4     service_interval INTERVAL YEAR TO MONTH;
  5     years_of_service NUMBER;
  6     months_of_service NUMBER;
  7  BEGIN
  8     start_date := TO_DATE('29-DEC-1988','dd-mon-yyyy');
  9     end_date := TO_DATE ('26-DEC-1995','dd-mon-yyyy');
 10
 11  END;
 12  /

PL/SQL procedure successfully completed.

SQL>