SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

AshK-OracleJul 19 2022

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.

This post has been answered by BluShadow on Jul 21 2022

Jump to Answer

Added on Jul 19 2022

#plsql

3 comments

460 views