RE: affected rows on delete cascade

From: Abhay Suresh Kulkarni <AbhKulkarni_at_manh.com>
Date: Tue, 9 Jan 2007 16:52:12 +0530
Message-ID: <D23ECE9D466B5C48BB8EF2A546A60AC40174D149@ma-india10.asia.manh.com>

You may use triggers on child table - "after/before delete".

Rgds
Abhay

Manhattan Assoicates
Phone: 40418080 Ext: 4635
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Johan Eriksson Sent: Tuesday, January 09, 2007 3:12 PM
To: oracle-l_at_freelists.org
Subject: affected rows on delete cascade

Is there a way to see how many rows a delete cascade deletes in the different tables affected by the statement? Seems it only return the number of the parent table and not the child and I need a way to make sure the it only deletes the rows I previously has been exported and counting the numbers in the tables before and after doesn't seem possible since new data is added all the time.

/johan
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 09 2007 - 05:22:12 CST