Forum Stats

  • 3,838,561 Users
  • 2,262,383 Discussions
  • 7,900,687 Comments

Discussions

I want to implement BULK delete in batches. Can anyone throw some light?

Below is the delete statement that I am currently using.

l_del_stmt := '
delete FROM xla_Transaction_reversals_int where transaction_number in (
select transaction_number from '||p_err_trx_tbl_adxx||')';
EXECUTE IMMEDIATE l_del_stmt;



Here, p_err_trx_tbl_adxx is the dynamic table.

I wanted to convert this into bulk delete in the batches of 1000.

Tagged:

Answers