Hi,

I am getting an Ora-00904 error ("TEST"."ENA": invalid identifier) when I try to issue this merge statement

merge into test
using (select ena from test1) t1
on (t1.ena = test.ena)
when matched then update set test.ena = t1.ena
when not matched then insert (test.ena) values (t1.ena)

if I issue this statement then I don't get the error and I don't get the right result as well

merge into test
using (select ena from test1) t1
on (t1.ena = 1)
when matched then update set test.ena = t1.ena
when not matched then insert (test.ena) values (t1.ena)


Here are structures and content of tables test and test1
desc test
Name Null? Type
------------ -------- ------------
ENA VARCHAR2(10)


desc test1
Name Null? Type
------------ -------- ------------
ENA VARCHAR2(10)


select * from test;
ENA
----------
1
2
3
4
5

select * from test1;
ENA
----------
3
4
5
6
7
8