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);

posted @ 2013-07-12 17:42  黑格  阅读(169)  评论(0编辑  收藏  举报