Oracle – Back To The Past – Using The Oracle Flashback Query Feature

Go back in time and look how something looked then - Isn’t this one of those things that is really cool? In Oracle, the set of features that enable this capability are clumped under “Oracle Flashback Features”. Technically, they can be bucketed as: Flashback query – as the name means, retrieve data as of a point …

Advertisement

Oracle – Interval Datatype – Extracting Components (Years/Months/Days/Hours/Minutues/Seconds)- Usage Example Reference

If you have not checked my quick intro to the Interval datatype here, please do so before reading on. Now, that we know the “interval” data type, let us see how we can extract out the individual components within it for both the “DAY TO SECOND” and “YEAR TO MONTH” variations. The following example should …