Home » Developer & Programmer » JDeveloper, Java & XML » Query for XML node
Query for XML node [message #112650] Mon, 28 March 2005 10:01
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
Member
Hello Experts,

I want to search Clob which is not having Node <What> value as SOPPapers

Attached xml structure having the <Actions> contains multiple <Action>and at least one <Action> node should having the node <What> node as value SOPPapers

So following is Valid Actions Node:-
<Actions>
<Action>
<ActionType>DeliverPapers</ActionType>
<What>SOPPapers</What>
<How>FedEx</How>
<Who>756014</Who>
<FedExService>FedEx2Day</FedExService>
</Action>
<Action>
<ActionType>Email</ActionType>
<What>CopyOfTransmittal</What>
<How>NotApplicable</How>
<Who>756014</Who>
</Action>
</Actions>

And InValid Actions Node is:-
<Actions>
<Action>
<Tag>AF6BAB0D68A140659A60A6968F9F00ED</Tag>
<ActionType>DeliverPapers</ActionType>
<What>CopyOfTransmittal</What>
<How>Mail</How>
<Who>829595</Who>
<MailService>RegularMail</MailService>
</Action>
<Action>
<Tag>C7B566BA63814E5E96742802A4BBE7BD</Tag>
<ActionType>Email</ActionType>
<What>CopyOfTransmittal</What>
<How>NotApplicable</How>
<Who>829595</Who>
</Action>
</Actions>


If Clob contains one Invalid Action node then it should be return in sql.

Pls. help me on this.

Thanks in advance.

Milind.

  • Attachment: Test.xml
    (Size: 2.26KB, Downloaded 1054 times)
Previous Topic: Remove XML node
Next Topic: Question regarding the processing of large XML files
Goto Forum:
  


Current Time: Tue Feb 27 04:30:20 CST 2024