stored procedure

[roli carol]

hi,
I need to write stored procedure for some queries,such as "select" and "insert" , I am not very confident with pl/sql at the moment as I have only just started this job. Can anyone help please.

thanks
R

[gitesh]

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;