tag:blogger.com,1999:blog-18037024.post5143808570587011892..comments2024-02-16T14:33:11.277+01:00Comments on Annals of Oracle's Improbable Errors: ORA-19025: EXTRACTVALUE returns value of only one nodeByte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-18037024.post-74637769088500677922011-11-08T10:06:18.400+01:002011-11-08T10:06:18.400+01:00Hi,
yes you can also do that albeit you'll get...Hi,<br />yes you can also do that albeit you'll get also the unwanted tags. <br />It really depends on the usage you are going to make of the content.<br /><br />Thanks<br />FlavioByte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-89347734273865941042011-11-07T23:50:14.124+01:002011-11-07T23:50:14.124+01:00How about the "node()" xpath function?
...How about the "node()" xpath function?<br /><br />select extract(xmltype('blah blah foo blah '), '/e/node()').getStringVal()<br />from dual;Kris Scoruphttps://www.blogger.com/profile/12853095309827550850noreply@blogger.com