Prev: Bequeath connections
Next: find position of row in set of rows
From: Frank van Bortel on 30 Jan 2010 05:20
UXDBA wrote:
> LOOP
> DELETE FROM T1
> WHERE dev = 1 AND ROWNUM <= batch_size;
>
> cnt := cnt + SQL%ROWCOUNT;
> COMMIT;
> DBMS_OUTPUT.put_line ( 'Deleted ['
> || cnt
> || '] rows from T1'
> );
> END LOOP;
>
I rest my case: Loop commit; end loop;

Please read the concepts guide. Then, read some pf tom kyte's books.
Start with the concepts guide, chapter three, and read it again.

Then start complaining about how stupid this approach is.

--

Regards, Frank van Bortel

Topposting in Usenet groups I regard as offensive - I will not reply
First  |  Prev  | 
Pages: 1 2
Prev: Bequeath connections
Next: find position of row in set of rows