Advertisement
Guest User

Untitled

a guest
May 23rd, 2019
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. DECLARE
  2. TYPE credit_card_typ
  3. IS VARRAY (100) OF VARCHAR2(30);
  4. v_mc credit_card_typ := credit_card_typ();
  5. v_visa credit_card_typ:= credit_card_typ();
  6. v_am credit_card_typ := credit_card_typ();
  7. v_disc credit_card_typ:= credit_card_typ();
  8. v_dc credit_card_typ:= credit_card_typ();
  9. BEGIN
  10. v_mc.EXTEND(6);
  11. v_visa.EXTEND(6);
  12. v_am.EXTEND(6);
  13. v_disc.EXTEND(6);
  14. v_dc.EXTEND(6);
  15. for i in 1..6 loop
  16. v_mc(i):= 'a';
  17. v_visa(i):= 'b';
  18. v_ac(i):= 'c';
  19. v_disc(i):= 'd';
  20. v_dc(i):= 'e';
  21. end loop;
  22. for i in 1..6 loop
  23. dbms_output.put_line('['||i||']'||' v_mc: '|| v_mc(i) || ' v_visa: ' || v_visa(i) || 'v_am: ' || v_am(i) || 'v_disc: '|| v_disc(i) || ' v_dc: ' || v_dc (i));
  24. end loop;
  25. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement