When checking a process for performance it’s useful to track fractions of seconds between steps. In the old days, we had to use dbms_utility.get_time, but with the introduction of TIMESTAMP in Oracle9i, it gets simpler. However, getting the differences between two timestamps is still more complicated than with dates. create or replace function milliseconds (pStartDate […]