SQL & PL/SQL

Hi,

THe basic difference between BLOB and CLOB would be BLOB stands for Binary Large Objects and CLOB stands for Character Large Objects. Is there any other specific difference between BLOB and CLOB.

Can i store XML data or file in BLOB or is it recommended to store in CLOB or XMLTYPE.


I have a xml file stored in a column of type BLOB . Can i convert that BLOB content to CLOB. if so how.

table structure goes something like this

CREATE TABLE clarity_log
             (
                          request_code NUMBER,
                          response_file BLOB ,
                          date_Created DATE DEFAULT SYSDATE
             )

In the above table we have xml data in response_file column

Please advise

Edited by: vine on Oct 21, 2010 10:50 PM