Sunday, October 07, 2007

using pl/sql dbms_random function for generating random values

UPDATE purchase_order_line
SET discount_total = (select round(dbms_random.value(0, 9999.22),2) from dual)
WHERE purchase_order_id = r_po.purchase_order_id;

No comments: