Advertisement
Guest User

Felipe Ribeiro

a guest
Jul 2nd, 2009
301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. DECLARE
  2.     TYPE L_NUM IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  3.     WCD_L L_NUM;
  4. BEGIN
  5.     FOR X IN 1..2000 LOOP
  6.        WCD_L(X) := X ;
  7.     END LOOP;
  8.    
  9.     FORALL X IN 1..2000 LOOP
  10.        DELETE FROM TABLE WHERE CAMPO = WCD_L(X);
  11. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement