I don't understand how this query works:
1 SELECT 2 EXTRACTVALUE(definition_xml.COLUMN_VALUE, 'SubtypeFieldInfo/DomainName') AS domain_name 3 FROM 4 SDE.GDB_ITEMS_VW i 5 JOIN SDE.GDB_ITEMTYPES it ON 6 i.Type = it.UUID 7 ,TABLE(XMLSEQUENCE(XMLType(Definition).Extract('/DETableInfo/Subtypes/Subtype/FieldInfos/SubtypeFieldInfo'))) definition_xml
What does the comma at the start of line #7 do?
My guess is that whoever wrote the query used some sort of SQL short-hand. Perhaps if someone could help re-format the query in 'beginner SQL' it might help.