Oracle插入随机生成的数据行

• 我们将向OE.ORDERS表中插入10万行数据，这10万行数据是随机生成的

DECLARE
  order_id INT;
  customer_id INT;
  ORDER_MODE VARCHAR(10);
  ORDER_TOTAL NUMBER(10,2);
  ORDER_STATUS INT;
BEGIN SELECT MAX(order_id) INTO order_id FROM oe.orders;
  FOR i IN 1..100000 LOOP
    order_id := order_id + 1;
    --generate a random CUSTOMER_ID from customers table
    SELECT CUSTOMER_ID INTO customer_id FROM (SELECT ROWNUM AS ROWNUM_,CUSTOMER_ID FROM OE.CUSTOMERS) WHERE ROWNUM_ = (SELECT trunc(dbms_random.value(1,319)) AS ROWNUM_ FROM dual);
    --generate a random ORDER_MODE
    SELECT decode(trunc(dbms_random.value(1,3)),1,'direct','online') INTO ORDER_MODE FROM dual;
    --generate a random ORDER_TOTAL
    SELECT trunc(dbms_random.value(5000,50000),2) INTO ORDER_TOTAL FROM dual;
    --generate a random ORDER_STATUS
    SELECT trunc(dbms_random.value(1,11)) INTO ORDER_STATUS FROM dual;

    insert into OE.ORDERS (ORDER_ID,ORDER_DATE,ORDER_MODE,CUSTOMER_ID,ORDER_STATUS,ORDER_TOTAL,SALES_REP_ID,PROMOTION_ID) values (order_id,SYSDATE,null,null);
  END LOOP;
  COMMIT;
END;
/

（编辑：鄂州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!