Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. 6:
  2.  
  3. DECLARE
  4. L_VARRAY moduls;
  5. BEGIN
  6. SELECT moduls INTO L_VARRAY
  7. FROM cicleformatiu
  8. WHERE id=1;
  9. L_VARRAY(2) := 'M7-INTERFICIES';
  10. UPDATE cicleformatiu
  11. SET moduls = L_VARRAY
  12. WHERE id=1;
  13. END;
  14.  
  15.  
  16. 7:
  17.  
  18. DECLARE
  19. L_VARRAY moduls;
  20. BEGIN
  21. SELECT moduls INTO L_VARRAY
  22. FROM cicleformatiu
  23. WHERE id=2;
  24. L_VARRAY(L_VARRAY.Count) := '';
  25. UPDATE cicleformatiu
  26. SET moduls = L_VARRAY
  27. WHERE id=2;
  28. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement