René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

XMLType

xmltype is a built in oracle type that can store well formed xml.

Methods

XMLType

The constructor.

createOnSchemaBasedXML

createSchemaBasedXML

createXML

extract(xml-type-instance,'xpath-expression')
extract(xml-type-instance,'xpath-expression', 'namespace')
See XPath query with XML DB for an example.

existsNode

extract

getBlobVal

getClobVal

create table some_xml_table of xmltype;
insert into some_xml_table values (xmltype('
  <things>
    <numbers><item>1</item><item>59</item></numbers>
    <animals><item>bird</item><item>cat</item><item>dog</item></animals>
  </things>
'));
set long 1000

select sxt.object_value.getClobVal()
from some_xml_table sxt;

getNamespace

getNumberval

getRootElement

getSchemaUrl

getStringVal

isFragment

isSchemaBased

Returns true if the instance is based on a schema, false otherwise.

isSchemaValid

isSchemaValidated

schemaValidate

setSchemaValidated

toObject

transform