Those functions with an asterisk (*) apply only to ArcSDE XML and not to native database XML.
XML Column and Column Info Functions (+/-)
XML Index, XML Index Info, and XML Tag Info Functions (+/-)
Top
XML Document Functions (+/-)
XML Schema Functions (+/-)