the following code is not working properly. when the record doesn't exist,
it's not inserting it. do i have to use another exception instead of
no_data_found?

regards.

begin
update table a
set ...
where...
exception when no_data_found then
insert into table a ...
end;
commit;




Oracle LazyDBA home page