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
Printable View
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
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;