Advertisement
Guest User

Untitled

a guest
May 19th, 2017
504
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.66 KB | None | 0 0
  1. BEGIN
  2.   FOR i IN 1..100 LOOP
  3.     INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,1,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
  4.     INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,2,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
  5.     INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,3,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
  6.     INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,4,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
  7.     INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,5,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
  8.   END LOOP;
  9. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement