ArcGIS - Query para obter valores de um dominio

query_dominio_valores.sql

SELECT
    *
FROM
    (
        SELECT
            extractvalue(codedvalues.column_value,'CodedValue/Code') AS code,
            extractvalue(codedvalues.column_value,'CodedValue/Name') AS value
        FROM
            sde.gdb_items_vw items
            INNER JOIN
                sde.gdb_itemtypes itemtypes
            ON
                items.type = itemtypes.uuid,
            TABLE ( xmlsequence(xmltype(definition).extract('/GPCodedValueDomain2/CodedValues/CodedValue') ) ) codedvalues
        WHERE
            itemtypes.name = 'Coded Value Domain'
        AND
            items.name = 'NOME_DO_DOMINIO'
    ) codedvalues
ORDER BY 1;