| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: updated rows count
Greg - How is your client executing this SQL update statement? If it is
executed from SQL*Plus, you are provided the number of rows updated as a
reply. If it is a one-time update, that might be the simplest. With other
tools, it depends a lot on the tool.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, May 30, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L
Hi All!
My client run big update 20,000 statements. I need to know how many rows was
updated (it's could be any number).
I thinking about triggers , but this table can be updated not only with this
big update. Other users can update rows too.
I need to know updated rows number just for this big update.
Thanks.
update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB',
atcapcty=850, atcapun=10000, atglcode='19.99GB', atus1='05/20/2002' where
ataltnbr='0000000';
update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=
850, atcapun=10000, atglcode='19.99GB', atus1='05/17/2002' where
ataltnbr='00000000';
update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB',
atcapcty= 400, atcapun=10000, atglcode='6.43GB', atus1='05/20/2002' where
ataltnbr='00000296';
............................
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Faktor
INET: FAKTORG_at_wyeth.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 30 2002 - 09:13:33 CDT
 |
 |