Store XML data as relational data into Oracle tables using Java and XMLType

Question

I want to store xml data into an Oracle 11g table as relational storage, not as CLOB or Binary storage. Then I should also be able to query and fetch this data from table into an XML file.

Any hint on how to write java code using XMLType to achieve this?

Any help would be appreciated.

Answer 1

• Start with the online Oracle XML DB Developer's Guide, specifically:
  • The Java DOM API for XMLType
  • Writing Oracle XML DB Applications in Java
  • Loading XML Content into Oracle XML DB Using Java
• See also the online Java reference doc: Oracle Database XML Java API Reference, 11g Release 2 (11.2), Class XMLType