check this may this will help u.


create or replace procedure a
as
date1 date;
begin
select sysdate into date1 from dual;
if (date1= '12-jun-01') then
insert into table values('s');
end if;
end;