oracle for 循环 更新字段

将密码字段更新成大写字母和数字组成的8位密码

BEGIN

FOR L_RECORD IN (select id from customer_config where salt is null) 
LOOP
        UPDATE customer_config
           SET passwd=dbms_random.string('x',8)
         WHERE id=L_RECORD.id;


 END LOOP;
 commit;
END;