hi! Guys ,
I am running a proc in which there is a loop
for i in 1..100000 loop
.....
end loop;
how do i monitor what "i" is
how do I keep watching "i" to see what value it is at ...
1) from sqlplus
OR
2) from OEM console
Printable View
hi! Guys ,
I am running a proc in which there is a loop
for i in 1..100000 loop
.....
end loop;
how do i monitor what "i" is
how do I keep watching "i" to see what value it is at ...
1) from sqlplus
OR
2) from OEM console
for i in 1..1000000 loop
v_count:=i;
if (v_count,10000)=0 then
update count_track set last_count=v_count; --temporary table to track
--the counter.
commit;
end if;
then select from that count_track table
Sorry please add Mod function in the first if command.