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;
Achievement provides the only real pleasure in life
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;
Posted by SF at 3:43 am
No comments:
Post a Comment