posted 11 years ago
Oracle docs
"You can specify delete clause by itself or with the merge_insert_clause. If you specify both, then they can be in either order. "
So we can have delete clause in merge_update_clause and merge_insert_clause.
And one more thing can we change the order of clauses When matched then update.....
When not matched then insert.......
can we change their order , I think we can as they are optional clauses with Merge statement.
Tea Addict, Oracle Java Programmer , Oracle SQL Expert , Oracle Java Web Component Developer, Oracle Web Service Developer