EXTRACTVALUE(XMLTYPE_instance,XPath_string) or
EXTRACTVALUE(XMLTYPE_instance,XPath_string, namespace_string)
e.g.
select extractvalue(details, '/SomeDoc/SomeDetail')
from SomeTable
Some mainly software/software development stuff I deal with at times.
Brak komentarzy:
Prześlij komentarz