| urgent: can i see rows_processed of pl/sql block [message #62439] |
Thu, 22 July 2004 00:02  |
BhavinShah
Messages: 105
Registered: February 2004
|
Senior Member |
|
|
hi gurus,
i have following block but i could not find no of rowsprocessed by this block.. can i see from data dictionary..
view v$sqlarea is giving no. of rowsprocessed of sql_text only no a pl/sql block.
Declare
cursor c1 is select mm_matcode,sum(nvl(mm_qty_hand,0)) mm_qty_hand ,sum(nvl(mm_val_hand,0)) mm_val_hand
from mf_matrl_new
and mm_qty_hand> 0
group by mm_matcode;
Begin
for i in c1 loop
update nonmoving.all_masters set qty_hand=qty_hand+i.mm_qty_hand,val_hand=val_hand+i.mm_val_hand where
matcode=i.mm_matcode;
end loop;
commit;
end;
pl.. give reply as early as posssible..
bye..
thax
|
|
|
|
| Re: urgent: can i see rows_processed of pl/sql block [message #62445 is a reply to message #62439] |
Thu, 22 July 2004 03:38  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Please post sql / plsql related questions in plsql forum.. folks over there can give a better solutions.
1 declare
2 cursor c1 is select * from emp;
3 a number;
4 begin
5 dbms_output.put_line ('The following employees are found');
6 for mag in c1 loop
7 exit when c1%notfound;
8 dbms_output.put_line(c1%rowcount||' '||mag.ename);
9 a:=c1%rowcount;
10 end loop;
11 --
12 -- if you want just the counts;
13 --
14 dbms_output.put_line('count of records '||a);
15* end;
dbadmin@constitution_lawd2 > /
The following employees are found
1 SMITH
2 ALLEN
3 WARD
4 JONES
5 MARTIN
6 BLAKE
7 CLARK
8 SCOTT
9 KING
10 TURNER
11 ADAMS
12 JAMES
13 FORD
14 MILLER
count of records 14
PL/SQL procedure successfully completed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
