delete query using execute Immediate

Question

I want convert varchar2 into date but its occur error give me solution

DECLARE
  ADATE VARCHAR2(100):='02/20/1981';
BEGIN
  EXECUTE IMMEDIATE 'DELETE FROM emp WHERE HIREDATE= '||to_char(to_date(ADATE,'mm/dd/yy'),'mm/dd/yy');
  DBMS_OUTPUT.PUT_LINE('DELETE');
END;

Answer 1

You can also use this one:

DECLARE
   ADATE   VARCHAR2 (100) := '02/20/1981';
BEGIN
   EXECUTE IMMEDIATE
         'DELETE FROM emp WHERE HIREDATE= :aDate' using TO_DATE(ADATE, 'mm/dd/yyyy');

   DBMS_OUTPUT.PUT_LINE ('DELETE');
  COMMIT;
END;