No of deleted records

rejith.ry · Post by **rejith.ry** » Fri Dec 01, 2006 4:22 am

How to get the number of records deleted from a table. I am using an oracle_OCI stage and a dummy file. Is there any way to capture the number of records deleted?(In select query we can get the link counts) Any help regarding this will be appreciated.

Nageshsunkoji · Post by **Nageshsunkoji** » Fri Dec 01, 2006 4:39 am

Hi,

Here one thing you can do, in your design is capture the all rows in a sequential file or Dataset before you delete records in DB.

Another option is ROLLBACK your databse to get your records, based on your commit interval.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 01, 2006 5:29 am

Count the table before and after the deletion. The difference will be the number of rows deleted.

aakashahuja · Post by **aakashahuja** » Fri Dec 01, 2006 5:31 am

Or may be do a count(*) soon after deleting the data (provided u knew the count before deleting)...