update 更新语句
update (select tuser.fauthority
from tc_user tuser
left join tc_userrole trole
on trole.fuserroleid = tuser.fuserroleid
where instr(trole.fuserrolename, '受理') > 0
and tuser.fuserlevelid = 3)
set fauthority = '1,2,3,4,5,6';
tc_userrole 主键是fuserroleid 这个没问题
还是会提示"ORA-01779: 无法修改与非键值保存表对应的列"