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: 64629
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: Thu Mar 30 15:34:33 CDT 2017

Total time taken to generate the page: 0.07622 seconds