RowCount in the window of command - pl/sql.

[LanderMen]

I want to know if you can help to determine the amount me of registries affected by query in the window of commandos.

I have proven with this query:

Select SQL%RowCount ace Dual CantRegistros from;

Thanks.
LanderMen.

 

[Marco Kalter]

The Command Window does already display the nukber of affected rows:

SQL> update dept set dname=upper(dname);

4 rows updated

This will be suppressed if the FEEDBACK option if turned off though, so you may first need to enable it:

SQL> set feedback on
SQL> update dept set dname=upper(dname);

4 rows updated

 

[LanderMen]

Thanks Marco.
Ok, But to obtain the total of Registries updated in 1 consults.
For example, I have this:

SQL> update dep Seth Code='909' where IdDep=100;
1 row updated

SQL> update dep Seth Code='909' where IdDep=100;
1 row updated.

to have query that says to me the total of registries but of all querys you execute.

For Example.

SQL>Select SQL%RowCount as CantReg from Dual;
2 rows Updated.

 

[Marco Kalter]

This information is currently indeed not available. You would need to write a PL/SQL Block and maintain a counter to accomplish this.