Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML in clob - querying tag attributes

833512Jan 23 2011 — edited Mar 8 2011
HI All ,

I've got XML in clob , I know already how to select tag values however I don't know how to get tag attribute.
Example of XML:

<?xml version="1.0"?>
<ts:Transaction msgid="46a8ff18" xmlns:ts="http://schemas.com/">
<TransactionSet representation="implicit" scope="entity">
<DateTime dateTimeFormat="YYYY-MM-DD HH24:MI:SS"></DateTimeFormats>
<Source>A</Source>
<Message_Version>1.0.0</Message_Version>
</TransactionSet>
<xt:event operation="DELETE" objectId="58" type_name="event" xmlns:xt="http://schemas.com">
<Event_Type>I</Call_Type>
<event_ID>80</Call_ID>
</xt:event>
</ts:Transaction>

so I do know how to get to event_ID '80' , what I'm after is operation="DELETE" and I would particularly want to option 'DELETE' value because of course I've got there other types, not only deletes.

Thanks
Evo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 5 2011
Added on Jan 23 2011
6 comments
2,995 views