It's been so long long that I've done this I am seeking some guidance.
The business problem I have is to derive a new calculated field to determine Throughput (Records Per Second)
Formula: (((batch_job_execution.end_time - batch_job_execution.start_time) * (24*60))) / (write_count)
The Results from above basically give me a Time Formatted Field and I am seeking an Intgerger field.
I take it I need to do a CAST or other type of formatting function(s) and it most likely needs to be broken down
within the calculated field above.
If someone can provide some guidance as how best to approach this problem, that'll be GREAT!!
If I need to provide some more information, please let me know as well.
Thank you for the quick response.
I will not be able to try this until tomorrow when I have access to the system.
At first glance I am questioning whether the TIMESTAMPDIFF function will carry over the timestamp
output format to the end result?
The end state result I am seeking will have to be an INTEGER reflecting (Records Per Second - 999999999)
I attempted to use the TIMESTAMPDIFF function and I am receiving error ORA-00904 invalid identifier.
I do not find this function in my Oracle SQL book so I'm assuming this might be a function that was created internally
within your enterprise. Please correct me if I am wrong. This may have to be the path I take. (Create a FUNCTION to perform TIMESTAMPDIFF processing)
Again, this is just some of my thoughts based on my research and I could be far off.
Please advise or confirm my suspicions.