Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CLOB Vs XMLTYPE

PrafullaJan 18 2011 — edited Jan 18 2011
Hi Guys,
In one of my applications , From the front end we are getting XML data and storing the xml data in the col of table which is CLOB type .
Today one of the application developer told that directly we can store the xml data into the data base.Could any one tell me the difference in storing the data in the clob and xml
and also what is the advantages of using xml over clob data type.

Any suggestions will be highly appreciated.


Thanks,
Prafulla
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2011
Added on Jan 18 2011
7 comments
13,900 views