Use SQL%ROWCOUNT
-----Original Message-----
From: abhijit_shrikhande@xxxxxxxxxxxxx
[mailto:abhijit_shrikhande@xxxxxxxxxxxxx]
Sent: December 30, 2002 1:56 PM
To: Oracle
Subject: [oracle] Row Count in a query
Hi there,
I have a PL/SQL Block which may contain an insert / update / delete
statement.
I want to know teh number of rows that have been affected by that sql
statement.
How do I find this out?
Any answers?
Thanks & Regards,
Abhijit
-------------------------------------------------
This mail sent through Nucsoft: http://nucsoft.co.in/
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to leave-oracle-1796914O@xxxxxxxxxxxxx
|
