When you use Merge statement, you cannot update the columns reference in the ON Clause.
Not many know that, Merge supports "WHERE Clause".
Add a Where Clause to your Update statement under "When Matched"
Merge Into ...
Using ()
On()
When Matched then
Update ...
Where ...
When Not Matched then
......
...which generates: SQL Error: ORA-00969: missing ON keyword
ReplyDelete