Home » SQL & PL/SQL » SQL & PL/SQL » XMLTYPE in Oracle (oracle)
XMLTYPE in Oracle [message #401444] Tue, 05 May 2009 01:15 Go to next message
madhavi babburi
Messages: 117
Registered: May 2009
Location: Hyderabad
Senior Member

I have lot of questions upon this.
1. Difference between CLOB and XMLTYPE in Oracle?
2. When we go for CLOB and XMLTYPE?

Please provide me some complex situations when using XMLTYPE in oracle.

Re: XMLTYPE in Oracle [message #401448 is a reply to message #401444] Tue, 05 May 2009 01:43 Go to previous messageGo to next message
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member

The CLOB datatype store up to 4 gigabytes of character data in the database. CLOBs store database character set data


facilitate native handling of XML data in the database. The following summarizes XMLType:

XMLType can be used in PL/SQL stored procedures as parameters, return values, and variables.
XMLType can represent an XML document as an instance (of XMLType) in SQL.
XMLType has built-in member functions that operate on XML content. For example, you can use XMLType functions to create, extract, and index XML data stored in Oracle9i database.
Functionality is also available through a set of Application Program Interfaces (APIs) provided in PL/SQL and Java.

[Updated on: Tue, 05 May 2009 01:44] by Moderator

Report message to a moderator

Re: XMLTYPE in Oracle [message #401451 is a reply to message #401448] Tue, 05 May 2009 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 63956
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quoted from what?

@madhavi babburi,
Please read the documentation before posting:
SQL Reference
Chapter 2 Basic Elements of Oracle SQL
Section Datatypes
CLOB Datatype


Re: XMLTYPE in Oracle [message #401454 is a reply to message #401451] Tue, 05 May 2009 01:52 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Be aware of the diffrent storage options for XMLTYPE.

This blog post is a good complement to the documentation

Previous Topic: SQL Expression
Next Topic: SQL: need to get data in a different way (merged)
Goto Forum:

Current Time: Fri Oct 28 14:47:41 CDT 2016

Total time taken to generate the page: 0.16454 seconds