Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- zad4 -----------------------------------------------------------------------------------------------------------------------
- BEGIN
- FOR i IN 1..1000000 LOOP
- INSERT INTO t1_user(id, name) VALUES (i, 'User nr ' || i);
- END loop;
- END;
- /
- BEGIN
- FOR i IN 1..1000000 LOOP
- INSERT INTO t2_ticket(id, id_user, name) VALUES(i, TRUNC(sys.DBMS_RANDOM.VALUE(1, 1000000)), 'Ticket nr ' || i);
- END loop;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement