SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 d1 DATE;
3 cd1 VARCHAR2(10);
4 cd2 VARCHAR2(10);
5 n1 NUMBER;
6 cn1 VARCHAR2(10);
7 cn2 VARCHAR2(10);
8 BEGIN
9 cd1 := '15-Nov-61';
10
11 d1 := cd1;
12 DBMS_OUTPUT.PUT_LINE('CD1 = ' || cd1);
13 DBMS_OUTPUT.PUT_LINE('d1 = ' || d1);
14
15 END;
16 /
CD1 = 15-Nov-61
d1 = 15-NOV-61
PL/SQL procedure successfully completed.
SQL>
SQL>
|