try it out!
--why dont u try giving alias name for table test as
merge into test t
using (select ena from test1) t1
on (t1.ena = t.ena)
when matched then update set t.ena = t1.ena
when not matched then insert values (t1.ena)
|
Results 1 to 5 of 5
Thread: ora-00904 and mergeThreaded View
|
Click Here to Expand Forum to Full Width |