select * from V$sql where command_type = 47
select * from user_procedures
从一个表选择数据更新另一个表数据
update MR_PF_USERINFO a set a.loginname =( select b.id from aa b where a.username = b.name AND a.department = b.Department andrownum=1)注意commit
update MR_PF_USERINFO a set a.remark =( select b.remark from aa2 b where a.loginname = b.id and a.remark is not null ) where a.remark is not null
Oracle字符串连接使用“||”进行字符串拼接