|
SQL>
SQL> SET ECHO ON
SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 payment_due_date DATE;
3 BEGIN
4 payment_due_date := TRUNC(SYSDATE);
5
6 DBMS_OUTPUT.PUT_LINE('Today is ' || TO_CHAR(SYSDATE,'dd-Mon-yyyy'));
7 DBMS_OUTPUT.PUT_LINE('Payment is due on ' || TO_CHAR(payment_due_date,'dd-Mon-yyyy'));
8
9 END;
10 /
Today is 02-Jun-2007
Payment is due on 02-Jun-2007
PL/SQL procedure successfully completed.
SQL>
SQL>
|