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