Counting deleted rows from child tables when using on delete cascade
Hello everybody,
I got a problem I can't solve.. I looked around but didn't find an answer so maybe you can help me.
Here at work they're asking me if we can use "on delete cascade" constraints on child tables but still being able to get the count of the rows deleted in each child.
So if I got a table "Father" and 6 tables "child1....child6" with on delete cascade constraint to table Father, and I delete 5 rows from the table Father, can I see how many rows I deleted in each table child1...child6? How?
If I use sql%sqlrowcount after the delete statement I only get the number of rows delete in the table Father...
Thank you in advance.
Giorgio.