René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Merge insert clause [Oracle SQL]

when not matched then insert (col-1 [ ..., col-n ] ) 
   values (expr-1 | default [ ..., expr-n | default ] ) 
[ where-clause ]
[ delete where-clause ]

Appearance

The merge-insert-clause appears as part in the merge sql statement.