Can you explain to me what XMLType table is? And how it is used in Oracle?
The XMLType is a datatype that lets you store XML documents in one column in an Oracle database table. Once you have the XML document in the XMLType column, you can use member functions to access, extract, and search for data in this column.
You are not bound to storing an entire XML document in one column of a table either. You can use Oracle's XML Developers Kit (XDK) to parse the contents of an XML document and load fields from the XML document into multiple columns of a table. Technet has tons of information on using XML with Oracle.
Dig Deeper on Oracle database design and architecture