Question

What is MERGE statement (9i)?

Answer 1

 the statement was introduced in Oracle 9ito conditionally insert or update data depending on its presence, a process also known as an "upsert". The MERGE statement reduces table scans and can perform the operation in parallel if required.