Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Length of service for INTERVAL YEAR TO MONTH

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>