ruoranff的博客

select email as "email", max(employee_name) as "name", max(user_pwd) as "user_pwd" from zguser.rlzy_cp_inv_userauth where INPUT_DT=to_date('2017/1/12','yyyy/mm/dd') group by email

插入8位随机密码update aa set user_pwd=(trunc(DBMS_RANDOM.value(10000000,99999999))) where input_dt = to_date('2017/1/12','yyyy/mm/dd')

create table aa --备份表名 as select * from bb --需要备份的表

两表关联更新-以更新邮箱为例update rlzy_cp_inv_userauth a --需要更新的表 set a.email=( --更新的字段 select distinct b.oaname||'@163.com' from common.dt_empinfo b --查找更新字段的表 where a.employee_id = b.em