SQL>
SQL> DECLARE
2 lv_current_date DATE := SYSDATE;
3 lv_current_month_txt VARCHAR(3) := TO_CHAR(SYSDATE, 'MON');
4 BEGIN
5 DBMS_OUTPUT.PUT_LINE('Current Date: ' ||lv_current_date);
6 DBMS_OUTPUT.PUT_LINE('Current Month: ' ||lv_current_month_txt);
7 END;
8 /
Current Date: 19-JUN-08
Current Month: JUN
PL/SQL procedure successfully completed.
SQL>
SQL>