René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
XMLType | ||
xmltype is a built in oracle type that can store well formed xml.
MethodsXMLType
The constructor.
createOnSchemaBasedXMLcreateSchemaBasedXMLcreateXMLextract(xml-type-instance,'xpath-expression') extract(xml-type-instance,'xpath-expression', 'namespace')
See XPath query with XML DB for an example.
existsNodeextractgetBlobValgetClobValcreate 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; getNamespacegetNumbervalgetRootElementgetSchemaUrlgetStringValisFragmentisSchemaBased
Returns true if the instance is based on a schema, false otherwise.
isSchemaValidisSchemaValidatedschemaValidatesetSchemaValidatedtoObjecttransform |