| 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 1555 times)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
