ТЕМА:

if insert = true then
commit;
else
...
end if;

begin
...
insert into ... (... ) select ... ;
if sql%rowcount>0 then
commit;
else
..;
end if;
...
end;

declare

col1_v my_tab.col1%TYPE;

begin

select col1 into col1_v from my_tab where col2=2;



if col1_v is null then 

   --some code


else 

  --some code


end if; 

end;

begin
Insert Into ....
Values....
Exception
when DUP_VAL_ON_INDEX
Then
Begin
........
End;
end;

begin

  update my_table set ... where id = :id;

  if sql%rowcout = 0 then

    insert into ...

  end if; 

end;

/

begin

  insert into ...

exception 

  when dup_val_on_index then

    update my_table set ... where id = :id;

end;

/