Home » SQL & PL/SQL » SQL & PL/SQL » SQL%ROWCOUNT (10g)
SQL%ROWCOUNT [message #310781] Wed, 02 April 2008 07:18 Go to next message
piscean_n
Messages: 36
Registered: December 2007
Member

We have one query to delete the parent table and with on delete cascade options the related information from child tables are also deleting.

to count the no of deleted rows we are using

total = sql%rowcount

but i want to know how many rows gets deleted from child tables also.because this total tells only rows deleted from parent table.

Re: SQL%ROWCOUNT [message #310782 is a reply to message #310781] Wed, 02 April 2008 07:19 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way.

Regards
Michel
Previous Topic: Autogenerated ID
Next Topic: toad error
Goto Forum:
  


Current Time: Wed Dec 07 18:45:46 CST 2016

Total time taken to generate the page: 0.05830 seconds