Re: Adding changed records

update yada;

if sql%rowcount = 0
then
  insert yada;
end if;

"Randy Harris" <randy.harris_at_nospam.net> wrote in message news:5iEta.4179$3f7.3486286_at_newssvr28.news.prodigy.com...
> Is there a simple means, with either SQL*Plus or SQL*Loader, to UPDATE
> records if they exist but INSERT if they do not?
>
> --
> Randy Harris
>
>
>
Received on Tue May 06 2003 - 07:45:05 CDT