ArcGIS - Dominios tabelas/features

dominios.sql

SELECT
    i.name AS item_name,
    extractvalue(definition_xml.column_value,'GPFieldInfoEx/Name') AS field_name,
    extractvalue(definition_xml.column_value,'GPFieldInfoEx/DomainName') AS domain_name,
    it.name AS item_type
FROM
    sde.gdb_items_vw i
    JOIN
        sde.gdb_itemtypes it
    ON
        i.type = it.uuid
    CROSS JOIN
        TABLE ( xmlsequence(xmltype(definition).extract('/DETableInfo/GPFieldInfoExs/GPFieldInfoEx') ) ) definition_xml
WHERE
    i.name IS NOT NULL
AND
    extractvalue(definition_xml.column_value,'GPFieldInfoEx/DomainName') IS NOT NULL 
ORDER BY i.name;

SELECT
    i.name AS item_name,
    extractvalue(definition_xml.column_value,'GPFieldInfoEx/Name') AS field_name,
    extractvalue(definition_xml.column_value,'GPFieldInfoEx/DomainName') AS domain_name,
    it.name AS item_type
FROM
    sde.gdb_items_vw i
    JOIN
        sde.gdb_itemtypes it
    ON
        i.type = it.uuid
    CROSS JOIN
        TABLE ( xmlsequence(xmltype(definition).extract('/DEFeatureClassInfo/GPFieldInfoExs/GPFieldInfoEx') ) ) definition_xml
WHERE
    i.name IS NOT NULL
AND
    extractvalue(definition_xml.column_value,'GPFieldInfoEx/DomainName') IS NOT NULL
ORDER BY i.name;