MySQL Forums
Forum List  »  Connector/Node.js

Re: How to access attributes using ExtractValue Function
Posted by: chris soutou
Date: November 30, 2009 02:30AM

SET @var_xml = your xml doc.

--For extract 'C' in EventActionCode

SELECT ExtractValue(@var_xml, '/AuditMessage/EventIdentification/@EventActionCode');

Options: ReplyQuote


Subject
Written By
Posted
Re: How to access attributes using ExtractValue Function
November 30, 2009 02:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.