delete in chunks or group of records
SQL> select count(*) from krsb_qrtz_job_details where job_name not in (select job_name from krsb_qrtz_triggers) and job_name not in (select job_name from krsb_qrtz_job_listeners);
COUNT(*) R
---------- -
768432
We're thinking we could use some PL/SQL cursor to delete X number of records at a time but we haven't been able to to come with the correct PL/SQL syntax. Can we have some guidance (syntax logic) we could use to perform such a delete in chunks/groups?