Record Found Update Else Insert

[MGoel]

Hi All,

How can i write a single sql statement where i check if record exists then just update else insert.

I have seen some where that it is possible but I am unable to search the solution on web or this forum.

Thanks in advance for any help.

Manoj

 

[Custom24]

I don't think it's possible from a single SQL statement.
See

http://www.oriole.com/papers/Its_the_algorithm.pdf

This guy is quite terse, but he does discuss a better way to do something he calls "UPSERT"
HTH

Mark

 

[karluk]

If you are on Oracle 9i, you might be able to make use of the merge statement, which either updates or inserts to a table based on the values in another table. However, I don't believe this command is available in Oracle 8i.