oracle生成随机数

UPDATE busi_chance_info t
   SET t.exp_amount =
       (SELECT floor(dbms_random.value(1, 10000000))
          FROM busi_chance_info
         WHERE busi_id = t.busi_id);

原文地址:https://www.cnblogs.com/javafan/p/3186759.html