RE: updated rows count
The SQL%ROWCOUNT and SQL%FOUND can be used to test for the status after an update operation. If SQL%FOUND is true then SQL%ROECOUNT will hold the number of rows updated. If the transaction has failed then %FOUND will be FALSE (and %NOTFOUND will be true) and %ROWCOUNT will be 0 HTH John -Original Message- Sent: 30 May 2002 14:49 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: updated rows count
select SQL%ROWCOUNT after update... Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 9:48 AM 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: updated rows count
Do this in PL/SQL, so you can use PL/SQL variables instead of data values embedded in the text of the SQL statement (much nicer on the Shared Pool). From PL/SQL, after each statement you can reference SQL%ROWCOUNT to get the number of rows actually updated... If you prefer Precompilers, you can get the same value from sqlca.sqlerrd[2] (I think)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 7:48 AM 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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. [EMAIL PROTECTED] -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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: updated rows count
After each of 20,000 update statements? Alexandre select SQL%ROWCOUNT after update... Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 9:48 AM 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: updated rows count
One approach: create a new user for this update, create a trigger to log only updates from that user, run the script as newly created user. Alexandre 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: updated rows count
usecat file_name | grep -C update JP On Thursday 30 May 2002 15:48, you wrote: 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: updated rows count
before the update: Select count(*) from table where ... Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 3:48 PM 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: updated rows count
Hi All!=0D My client run big update 20,000 statements. I need to know how many rows wa= s updated (it's could be any number). =0D I thinking about triggers , but this table can be updated not only with thi= s big update. Other users can update rows too.=0D I need to know updated rows number just for this big update.=0D Thanks.=0D =0D update assethdr set atopsys=3D 'MS Windows 95 4.00',atdept=3D'256MB', atcap= cty=3D850, atcapun=3D1, atglcode=3D'19.99GB', atus1=3D'05/20/2002' wher= e ataltnbr=3D'000';=0D update assethdr set atopsys=3D 'MS Windows 95 4.00',atdept=3D'256MB', atcap= cty=3D 850, atcapun=3D1, atglcode=3D'19.99GB', atus1=3D'05/17/2002' whe= re ataltnbr=3D'';=0D update assethdr set atopsys=3D 'MS Windows 2000 Pro 5.00',atdept=3D'128MB',= atcapcty=3D 400, atcapun=3D1, atglcode=3D'6.43GB', atus1=3D'05/20/2002= ' where ataltnbr=3D'0296';=0D =0D =0D =0D Several solutions. SELECT COUNT(*) with the same WHERE clause is an obvious solution. Checking ROWS_PROCESSED before and after the run in V$SQLAREA for the relevant line may be another option. Tracing the process is possible too. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: updated rows count
Create After update trigger on table assethdr. And let the trigger insert ROWID of changed rows in other table. And you can always do SELECT DISTINCT ROW_ID FROM my_spy_table_with_rowids :-] JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 3:48 PM 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: updated rows count
if you're going to do all that, why not simply CREATE SNAPSHOT LOG ... WITH ROWID against the table in question, and have the RDBMS do all that coding for you? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 12:38 PM Create After update trigger on table assethdr. And let the trigger insert ROWID of changed rows in other table. And you can always do SELECT DISTINCT ROW_ID FROM my_spy_table_with_rowids :-] JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 3:48 PM 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: updated rows count
OPS, sorry I thought that you mean one update that updates about 20,000 rows. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 5:04 PM before the update: Select count(*) from table where ... Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 3:48 PM 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=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).