MERGE INTO

MERGE INTO [TABLE_NAME]
USING DUAL
ON (KEY_COLUMN = :KEY_COLUMN)
WHEN MATCHED THEN
 UPDATE SET
        UPDATE_COLUMN = :UPDATE_COLUMN
WHEN NOT MATCHED THEN
 INSERT (INSERT_COLUMN)
 VALUES (:INSERT_COLUMN)