xml query with sql

Question

I have an XML column:

<xmlList> 
   <XMLEntity> 
      <sug>ACHER</sug>
   </XMLEntity>

  <XMLEntity> 
      <sug>DOA</sug>
   </XMLEntity>
</xmlList>

In this way I get just the sug node:

SELECT XMLSERIALIZE(XMLQUERY ('//xmlList/XMLEntity/sug' passing 
KTOVET ) as char large object) as XXX 
FROM "TABLE"

How can I get the sug nodes where its value is "ACHER"?

har07 · Accepted Answer · 2014-11-18 04:31:54Z

1

You can try using this XQuery expression :

//xmlList/XMLEntity/sug[.="ACHER"]

answered Nov 18, 2014 at 4:31

har07

89.5k12 gold badges87 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3165438 Over a year ago

I get lines that their sug but their value is DOA as empty lines, since they indeed have sug. How can I filter them so they will not appear? Thanks in advance1

Collectives™ on Stack Overflow

xml query with sql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related