SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I determine how many items I processed per minute

John MCGrathOct 4 2019 — edited Oct 4 2019

What I have are 2 time stamps START_TIME and END_TIME and another element WRITE_COUNT, containing how may items were written/processed during the time between the start and end. I would like to calculate how many were done per minute in my query while returning additional fields from the table. I've found plenty of posts comparing 2 dates/timestamps but I'm having trouble figuring out how to do what I need. I'll also add, I'm a beginner SQL user.

Thanks.

This post has been answered by mathguy on Oct 4 2019

Jump to Answer

Added on Oct 4 2019

6 comments

2,100 views