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
Sapna.s
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,
Sapna

Report message to a moderator

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
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you, perhaps, mean to change it to a CLOB instead of a BLOB?

Report message to a moderator

Previous Topic: problem on declaration section
Next Topic: Urgent help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 17:04:30 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.