RE: affected rows on delete cascade
- From: "Abhay Suresh Kulkarni" <AbhKulkarni@xxxxxxxx>
- To: <valpis@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Jan 2007 16:52:12 +0530
You may use triggers on child table - "after/before delete".
Rgds
Abhay
Manhattan Assoicates
Phone: 40418080 Ext: 4635
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johan Eriksson
Sent: Tuesday, January 09, 2007 3:12 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: affected rows on delete cascade
Hi
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
