Problem solve
Get help with specific problems with your technologies, process and projects.
What is a XMLType table?
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments