Hi I'm trying to use the merge command but have encountered a problem which does not seem to make sense. I am running the following code:
merge into dest
on (dest.client_number = src.nclient)
when matched then
dest.client_number = src.nclient
when not matched then
when trying to run it I get the following error:
ORA-00904: "DEST"."CLIENT_NUMBER": invalid identifier
Now this table exists and the user I am using is the owner of the table so I can't understand what's wrong. Any ideas?
The version of Oracle I am using is 220.127.116.11.0.