Home » SQL & PL/SQL » SQL & PL/SQL » Re: Please help on an insert
Re: Please help on an insert [message #35613] Mon, 01 October 2001 09:02
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
I would recommend this approach:

update t set c2 = 'something' where c1 = the_key;

if sql%notfound then
insert into t values (the_key, 'something');
end if;

----------------------------------------------------------------------
Previous Topic: oracle Error
Next Topic: Re: oracle Error
Goto Forum:
  


Current Time: Thu Mar 28 04:04:24 CDT 2024