I have tables in an Oracle 18c GDB that I integrate to a work order management system.
I create views on the tables to translate the data. For example, I translate
codes to domain
I do this by joining to a view that extracts the domain values from the GDB system tables:
select substr(extractvalue(codedvalues.column_value,'CodedValue/Code'),1,255) as code, substr(extractvalue(codedvalues.column_value,'CodedValue/Name'),1,255) as description from sde.gdb_items_vw i join sde.gdb_itemtypes it on i.type = it.uuid, table(xmlsequence(xmltype(definition).extract('/GPCodedValueDomain2/CodedValues/CodedValue'))) codedvalues where i.name = 'ASSET_STATUS'
In addition to getting the domain's description, I would also like to select the date that the domain was last updated.
However, I don't see any sort of date field in
sde.gdb_items_vw and I don't think
scn_to_timestamp(ora_rowscn) will work.
How can I select a domain's last update date?