procedure ins_or_upd ( s varchar2 ... ) is
begin
   update ... where column=s;
   if SQL%rowcount = 0 then 
       insert ...
   end if;
end;