Have Autonomous AI db up and running
Connected with sql developer
—
CREATE TABLE orders (
id NUMBER,
customer_id NUMBER,
amount NUMBER,
created_at DATE
);
Insert data:
BEGIN
FOR i IN 1..2000000 LOOP
INSERT INTO orders VALUES (
i,
MOD(i,1000),
DBMS_RANDOM.VALUE(10,1000),
SYSDATE - DBMS_RANDOM.VALUE(0,365)
);
END LOOP;
COMMIT;
END;
/
FOR i IN 1..2000000 LOOP
INSERT INTO orders VALUES (
i,
MOD(i,1000),
DBMS_RANDOM.VALUE(10,1000),
SYSDATE - DBMS_RANDOM.VALUE(0,365)
);
END LOOP;
COMMIT;
END;
/
jonathan lewis