PL-SQL Oracle --- Order List for Qianqian(Oracle)

CREATE TABLE test5(orderid number(10), price number(10),afterdiscount number(10),discount varchar2(20),saledate DATE);

DECLARE
 randomNum NUMBER;
 discounted NUMBER;
 havediscount varchar2(20);
 nodiscount varchar2(20);
  randate DATE;
  indexId NUMBER;

 BEGIN
 
havediscount := '5% discount';
nodiscount := 'no discount';

FOR indexId IN 1..50
LOOP
randomnum := trunc(dbms_random.value(1,200));
randate := TO_DATE(TRUNC(DBMS_RANDOM.VALUE(2454467,2454467+364)),'J');
 IF randomnum > 70 THEN
    discounted := randomnum * 0.95;
    INSERT INTO test5 VALUES(indexId, randomnum,discounted,havediscount,randate);
 ELSE
    INSERT INTO test5 VALUES(indexId, randomnum,randomnum,nodiscount,randate);
 END IF;
 
END LOOP;



END;

SELECT * FROM test5