My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Felipe Ribeiro

By: a guest | Jul 2nd, 2009 | Syntax: SQL | Size: 0.24 KB | Hits: 174 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  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.     FOR X IN 1..2000 LOOP
  10.        DELETE FROM TABLE WHERE CAMPO = WCD_L(X);
  11. END;
create new paste | create new version of this paste RAW Paste Data