Search notes:

Oracle: EXTRACTVALUE

extractvalue applies an XPath expression to an XMLType and returns a scalar value.

select
   extractValue(
     XMLType(
'<R>
   <e id="1">one</e>
   <e id="2">two</e>
   <e id="3">three</e>
</R>')
        ,
  '/*/e[@id="2"]') id_2
from
   dual

Oracle: EXTRACTVALUE

See also