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
Hi,

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.

Regards,
Madhu.
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
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Quote:

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

XMLType

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: 64120
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
XMLType

Regards
Michel



Re: XMLTYPE in Oracle [message #401454 is a reply to message #401451] Tue, 05 May 2009 01:52 Go to previous message
tahpush
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: Tue Dec 06 13:53:52 CST 2016

Total time taken to generate the page: 0.06901 seconds