[Deploying Sakai] Lessons on Oracle possible issue

[Charles Hedrick]

You could do this in mysql as well. But unless it’s doing something very tricky, it would be parsing the xml file to a DOM for each column, and then doing a DOM search. I’d much rather retrieve the whole thing, parse it once on the client side and then pull individual values out. Of course that would require code in the client that knows it’s stored in XML. But that could be hidden in the lowest level of the code.

On May 2, 2014, at 9:43 AM, Steve Swinsburg <steve.swinsburg at gmail.com> wrote:

> SELECT
>   EXTRACTVALUE(ac.xml, '/content/@title') assignment_title
> , EXTRACTVALUE(ac.xml, '/content/@datecreated') date_created
> , EXTRACTVALUE(ac.xml, '/*/properties/property[@name=''CHEF:creator'']/@value') assignment_creator
> FROM assignment_content ac
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20140502/e6b51b16/attachment.html