|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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 ]
The merge-insert-clause appears as part in the merge sql statement.