Q
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close