Q&A BY TAG 'XPATH'

You must sign in to ask a question. If you do not have an account, you can register here

I'm not able to retrive attribute from xml using xpath
answered 15-04-2021 08:33:52 -0400

I want to retrieve an attribute from xml value using xpath but I cannot retrieve it. If I execute statemet: SELECT cast('text', XPATH ( CAST ('xml' , '<Root attr="1111"> test </Root>' ) , '/Root/text()', true)) as xpath_results FROM Dual();...

Answers: 3

XPATH

How to get result in array or registered ?
answered 26-06-2019 02:06:07 -0400

SELECT xpath ( cast ('xml', '<?xml version="1.0" encoding="ISO-8859-1"?> <a> <b>Hello</b> <b>World</b> </a>' ) , '/a/b/text()', false) as xpath_results FROM Dual(); The result is xpath_results HelloWorld ...

Answers: 3

XPATH XML