SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 v_sysdate DATE := SYSDATE;
3 v_systimestamp TIMESTAMP := SYSTIMESTAMP;
4 v_date DATE;
5 v_number NUMBER(10);
6 BEGIN
7
8 -- Calculate the months between two dates
9 v_number := MONTHS_BETWEEN('13-JUN-1973', '23-JAN-1973');
10 DBMS_OUTPUT.PUT_LINE(v_number);
11
12 END;
13 /
5
PL/SQL procedure successfully completed.
SQL>