查看正在运行的oracel存储过程

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字符串连接使用“||”进行字符串拼接