Advertisement
Guest User

Untitled

a guest
Jan 19th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. -- zad4 -----------------------------------------------------------------------------------------------------------------------
  2. BEGIN
  3. FOR i IN 1..1000000 LOOP
  4. INSERT INTO t1_user(id, name) VALUES (i, 'User nr ' || i);
  5. END loop;
  6. END;
  7. /
  8.  
  9.  
  10. BEGIN
  11. FOR i IN 1..1000000 LOOP
  12. INSERT INTO t2_ticket(id, id_user, name) VALUES(i, TRUNC(sys.DBMS_RANDOM.VALUE(1, 1000000)), 'Ticket nr ' || i);
  13. END loop;
  14. END;
  15. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement