Home » SQL & PL/SQL » SQL & PL/SQL » update and insert
update and insert [message #220] Tue, 29 January 2002 08:50 Go to next message
Ildar
Messages: 3
Registered: January 2002
Junior Member
Is it possible to create a SQL operator performing the following ?:
1. UPDATE of the row
2. if the UPDATE was failed because of row absence then INSERT with the same params ?

Thanks in advance,

Ildar.
Re: update and insert [message #222 is a reply to message #220] Tue, 29 January 2002 14:11 Go to previous message
Raj
Messages: 411
Registered: November 1998
Senior Member
cursor c1 is
select column from table where condition;
open c1;
fetch c1 into cur;
if cur%found then
update stetement;
else
insert statement;
end if;
Previous Topic: Re: PLS-00201: identifier 'BRANCH.BRANCH' must be declared
Next Topic: need a solution
Goto Forum:
  


Current Time: Fri May 29 09:58:01 CDT 2020