XML XMLSequence

select extractValue(value(t),'b') result

  from table(XMLSequence(XMLType('<a><b>v1</b><b>v2</b></a>').extract('a/b'))) t;