Assign date value as string to date type variable
SQL> Declare 2 myDate date; 3 Begin 4 myDate := '29-SEP-2005'; 5 dbms_output.putline(myDate); --show date 6 End; 7 / SQL>