|
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
9 start_date := TO_DATE('29-DEC-1988','dd-mon-yyyy');
10 end_date := TO_DATE ('26-DEC-1995','dd-mon-yyyy');
11
12 END;
13 /
PL/SQL procedure successfully completed.
SQL>
|