SQL>
SQL> declare
2 v_temp_dt DATE;
3 v_count_nr NUMBER(10);
4 begin
5
6 -- Explicit declaration of format mask.
7 v_temp_dt := to_DATE('01-JAN-2007','dd-mon-yyyy');
8
9 end;
10 /
PL/SQL procedure successfully completed.
SQL>