Oracle timestamp difference SQL

Often in performance testing we need to get processing times of transactions which have been timestamped in a log somewhere. This usually entails multiple log entries for the same transaction which have been processed for in and out entries. Consider timekeeper entries for example, employees clocking in for work and out of work multiple times thoughout the day. Read on for an example SQL that can be helpful

Continue reading