New answers tagged oracle
You may be able to do this in PostGIS by using Foreign Data Wrappers (FDW). There is one for Oracle and another that can wrap any OGR datasource (which should include MySQL). I've never tried this (why would I store data outside PostGIS?) but this blog post suggests it is quite easy to use.
SQL-only / database-only possible solutions: A. - add a timestamp column to every layer using systimestamp as default value, then query for latest timestamp B. - add a trigger ON INSERT and ON UPDATE to every layer table, that updates last modified date value for each layer, on a table of your own.
Top 50 recent answers are included