Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- FOR i IN 1..100 LOOP
- INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,1,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
- INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,2,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
- INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,3,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
- INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,4,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
- INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'dummy'||i||'@gmail.com' ,5,ROUND(DBMS_RANDOM.VALUE() * 4) + 1,'N');
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement