|
SQL>
SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 d1 DATE;
3 d2 DATE;
4 d3 DATE;
5 d4 DATE;
6 n1 NUMBER;
7 n2 NUMBER;
8 n3 NUMBER;
9 BEGIN
10 d1 := TO_DATE('1/1/02','mm/dd/yy');
11
12 DBMS_OUTPUT.PUT_LINE('d1 = ' || TO_CHAR(d1,'dd-Mon-yyyy'));
13
14 END;
15 /
d1 = 01-Jan-2002
PL/SQL procedure successfully completed.
SQL>
|