XMLTYPE: methods

XMLTYPE is use by Oracle for implementing XML database functions. One option is to mimic what Oracle has exactly. Another way is to implement minimal support in the server itself and provide additional features in a stored procedure package. Oracle 19 feature list is here: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/XMLTYPE.html

This task is about implementing XMLTYPE methods, the syntax like xmltype_expression.extract(), for example

select xmlelement(e, ename).extract ('//text()') from emp;

Members and static routines supported by XMLType in Oracle:

Member functions:

• createNonSchemaBasedXML
• createSchemaBasedXML
• existsNode
• extract
• getBlobVal
• getClobVal
• getNamespace
• getNumberVal
• getRootElement
• getSchemaURL
• getStringVal
• isFragment
• isSchemaBased
• isSchemaValid
• isSchemaValidated
• transform

Member procedures:

• schemaValidate
• setSchemaValidated
• toObject

Constructors:

• XMLType

Static functions:

• createXML