Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO VOUCHER (VOUCHER_NUMBER, BOOK_ID, DENOMINATION)
- SELECT a.a1, b.ID, b.DENOMINATION FROM
- (SELECT rownum a1 FROM dual CONNECT BY rownum <= 10000000) a, BOOK b
- where a.a1 between b.START_NUMBER and b.START_NUMBER+b.UNITS-1;
- for 1 to BOOK.units loop
- INSERT INTO VOUCHER (
- -- VOUCHER_NUMBER handled by auto-increment
- BOOK_ID
- , DENOMINATION
- )
- SELECT
- b.ID
- , b.DENOMINATION
- FROM BOOK b
- WHERE b.ID = [book ID];
- end loop
Add Comment
Please, Sign In to add comment