Geographic Information Systems Asked by MapMan on March 22, 2021
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.
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP