|
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>
|