I have an oracle database that contains versioned and non versioned feature classes.
Each feature class has editor tracking enabled, so when a feature is added or updated, I can see the date the change occurred, and from that can calculate the maxdate of that featureclass to get when it was last "modified". However if a feature is deleted that information is not captured within the featureclass (therefore the last modified date will be incorrect). I know that if it is versioned the OBJECTID is captured in the deletes table, but there is no date field (that i am aware of).
Is there a SQL way of getting the last modified date of a feature class, whether it is versioned or non versioned and regardless of whether it is an insert, update or delete.