Guest User

Untitled

a guest
Feb 23rd, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. SELECT
  2. XMLCAST(XMLQUERY('string(/a/b/@foo)' PASSING X) AS VARCHAR(20))
  3. FROM (
  4. SELECT xmlparse('<a><b foo="bar"/><c/></a>')
  5. FROM sysibm.sysdummy1
  6. ) AS X(X)
Add Comment
Please, Sign In to add comment