Home » SQL & PL/SQL » SQL & PL/SQL » How to convert VARCHAR2 to BLOB ?
How to convert VARCHAR2 to BLOB ? [message #212595] Sat, 06 January 2007 04:33 Go to next message
Messages: 1
Registered: January 2007
Junior Member
Hi All,
I am having a table with a VARCHAR2 column,Now i have to change the datatype of this column to a BLOB.

I created a new table with BLOB column n tried to insert VARCHAR2 data from previous table to newly created table in BLOB column.It got inserted but when i see the contents of BLOB column it is not proper.

Please suggest me how can i convert a VARCHAR2 datatype in BLOB.

Thanks & Regards,
Re: How to convert VARCHAR2 to BLOB ? [message #212608 is a reply to message #212595] Sat, 06 January 2007 09:22 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you, perhaps, mean to change it to a CLOB instead of a BLOB?
Previous Topic: problem on declaration section
Next Topic: Urgent help
Goto Forum:

Current Time: Wed Aug 16 07:57:25 CDT 2017

Total time taken to generate the page: 0.08825 seconds