Re: SQL%ROWCOUNT

"Tony Andrews" <[email protected]> Tue, 7 Jan 2003 13:33:02

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-824125-2003.01.07-13.20.21--gcdod-oracle#[email protected]>

> Does SQL%ROWCOUNT work for deletes, updates and inserts as well as 
selects?

It would have been quicker to find out the answer for yourself than to ask 
the question!  But yes, it does:

SQL> select count(*) from t;

  COUNT(*)
----------
         3

SQL> ;
  5  /
rows deleted = 3

PL/SQL procedure successfully completed.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].