Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to display status in long PL/SQL jobs?
I have a PL/SQL or SQL block that executes a fair amount of time. It goes something like this. . .
.
.
select A, sum(B)
from TABLE1
group by A
.
.
There are about 100 different A's out in TABLE1 and it takes about 30 minutes for it to finish.
Can anybody show me a simple way of reporting the status of the query as it processes. Some thing like . . .
A=1 done A=2 done A=5 done
I'm looking for a SQL, PL/SQL, or Pro*C solution to this.
Thanks for any info.
Please respond to zlm101_at_psu.edu Received on Sun Dec 01 1996 - 00:00:00 CST
![]() |
![]() |