check if two xml nodes exists within an xml parent

Question

I'm trying to determine whether an xml tag has two specific child tags.

The XML Clob has a format like this:

<ProductS>
<id>1</id>
<Discount></Discount>
<Promotion></Promotion>
</ProductS>
<ProductS>
<id>2</id>
<Discount></Discount>
</ProductS>

I want my xmlquery to go through this XML clob and identify if there is an xml tag that contains these two discount and promotion types under ProductS.

My code currently looks like this:

select existsNode(xmltype(rec1.xml), '/ProductS/Discount') into v_node_exists_discount from dual;
select existsNode(xmltype(rec1.xml), '/ProductS/Promotion') into v_node_exists_promotion from dual;

Will ANDing these two statements above work in this type of scenario or do I need to do something else.

Thanks.

har07 · Accepted Answer · 2015-05-18 10:06:52Z

4

I'm not familiar with oracle but you can easily query <ProductS> having both <Discount> and <Promotion> using single xpath like so :

/ProductS[Discount and Promotion]

The oracle query might look about like this :

select existsNode(xmltype(rec1.xml), '/ProductS[Discount and Promotion]') 
into v_node_exists_discount_and_promotion 
from dual;

answered May 18, 2015 at 10:06

har07

89.5k12 gold badges87 silver badges143 bronze badges

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

Collectives™ on Stack Overflow

check if two xml nodes exists within an xml parent

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related