XML in clob - querying tag attributes
833512Jan 23 2011 — edited Mar 8 2011HI 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