Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- some_tbl.xmldata='<a><b>foo</b><b>bar baz</b></a>'
- select ExtractValue(some_tbl.xmldata, '/a/b') as xml_b from some_tbl where 1
- SELECT TRIM(TRAILING ';' FROM ExtractValue(REPLACE(some_tbl.xmldata, '</b>', ';</b>'), '/a/b')) as xml_b
- FROM some_tbl
- WHERE 1
Add Comment
Please, Sign In to add comment