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;

----------------------------------------------------------------------

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 06 21:44:53 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.