I want use ref cursor in a loop. Does any one have any example of those?
Actually my requirement is to calculate avg of time taken for the process at each 10 min time interval.
Lets say if a job started at 9pm and ended at 10pm,
I want to the result as
Avg time taken to process at 9:00 - 9:10 interval =
Avg time taken to process at 9:10 - 9:20 interval =
Avg time taken to process at 9:20 - 9:30 interval =
Avg time taken to process at 9:50 - 10:00 interval =
Please suggest me any idea?