RE: Row Count in a query
"Suneet Madhok" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-815637-2002.12.30-08.30.17--gcdod-oracle#[email protected]> |
Use SQL%ROWCOUNT -----Original Message----- From: [email protected] [mailto:[email protected]] 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 [email protected].