SQL%ROWCOUNT
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-816644-2002.12.31-03.57.04--gcdod-oracle#[email protected]> |
Does SQL%ROWCOUNT work for deletes, updates and inserts as well as selects? -Abhijit Quoting Oracle digest <[email protected]>: > ----------------------------------------------- > When replying to the digest, please quote only > relevant material, and edit the subject line to > reflect the message you are replying to. > ----------------------------------------------- > > The URL for this list is: > http://p2p.wrox.com/list.asp?list=oracle > ORACLE Digest for Monday, December 30, 2002. > > 1. Row Count in a query > 2. RE: Row Count in a query > > ---------------------------------------------------------------------- > > Subject: Row Count in a query > From: [email protected] > Date: Mon, 30 Dec 2002 08:26:15 +0000 > X-Message-Number: 1 > > 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/ > > > ---------------------------------------------------------------------- > > Subject: RE: Row Count in a query > From: "Suneet Madhok" <[email protected]> > Date: Mon, 30 Dec 2002 14:06:49 +0530 > X-Message-Number: 2 > > > 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%%. > > > > > --- > > END OF DIGEST > > --- > Change your mail options at http://p2p.wrox.com/manager.asp or > to unsubscribe send a blank email to %%email.unsub%%. > > ------------------------------------------------- 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 protected].