Insert or update in one SQL statement

[Tve]

Hi,

I'm not a whiz in SQL, so please forgive my question if it is way out of line, but here goes:

I'm looking for a way to update a record in an Oracle table if it already exists, else to insert it as new record.

I'm currently first running a select statement with a where condition to see if the record exists: if it does, I concatenate a UPDATE statement, and if it doesn't I concatenate a INSERT statement.

It would be nice if I could do this in one statement, something like "UPDATE OR INSERT...." and skip the select statement.

Would this be possible?
AD AUGUSTA PER ANGUSTA

Thierry

 

[pipk]

if you are using SQL embedded within another language then this is achievable using an IF statement to test the return code of the update or insert, otherwise I am not sure it can be done.