merge into sc_menu_role_tb as t1 using ( select ‘JUTEST02’ menu_no, -1024 role_no, sysdate() create_time from dual) as t2 on t1.menu_no = t2.menu_no
when matched then update set t1.role_no = t2.role_no, t1.create_time = t1.create_time when not matched then insert values(t2.menu_no, t2.role_no, to_char(t2.create_time, ‘YYYY-MM-DD HH24:MI:SS’));
执行失败(语句1)
第5 行附近出现错误[-4022]:
列表不匹配