Home -> Usenet -> comp.databases.oracle -> XML to database table

XML to database table

From: C. R. Soza <crsoza_at_hotmail.com>
Date: 21 May 2002 05:42:31 -0700
Message-ID: <c18ea449.0205210442.77e71669_at_posting.google.com> 






I have xml docs in the database in CLOB columns. The xml doc is of the
form similar to:



<?xml version="1.0" encoding="UTF-8" ?> 


- <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns"


xmlns:dc="http://purl.org/dc/elements/1.0/"
xmlns:dcq="http://purl/org/dc/qualifiers/1.0/">


- <rdf:Description rdf:about="no1.txt">



    
  
  •   <dc:title>
  
  •   <rdf:Alt>
  <rdf:li xml:lang="en-GB">no1.txt</rdf:li> 
  </rdf:Alt>
  </dc:title>
  
  •   <dc:date>
  
  •   <rdf:Description>
  <dcq:dateType>ISSUE</dcq:dateType> 
  <dcq:dateScheme>W3CDTF</dcq:dateScheme> 
  <rdf:value>2002-04-26</rdf:value> 
  </rdf:Description>
  </dc:date>
  
  •   <dc:date>
  
  •   <rdf:Description>
  <dcq:dateType>AVAILABLE</dcq:dateType> 
  <dcq:dateScheme>W3CDTF</dcq:dateScheme> 
  <rdf:value>2002-05-01</rdf:value> 
  </rdf:Description>
  </dc:date>
  
  •   <dc:identifier>
  
  •   <rdf:Description>
  <dcq:identifierType>ABC</dcq:identifierType> 
  <rdf:value>a90a16550a65659c00528f749a64a828</rdf:value> 
  </rdf:Description>
  </dc:identifier>
  </rdf:Description>
  </rdf:RDF>






I want to extract the issue date from this xml document. Can someone
please help me



Thanks 


Chris
Received on Tue May 21 2002 - 14:42:31 CEST












Original text of this message