Please anybody search blob converter?

Asked By 40 points N/A Posted on -
qa-featured

Hello Friends,

I have a BLOB(binary large object) datatype field in my database and i wish to store blob datatype into a string datatype field.But first I must convert blob datatype into string datatype.

I have search blob converter,but could not gather much information from the internet.So,friends please provide me the effective solution to convert blob to string datatype.

Thanks.

SHARE
Answered By 270 points N/A #185019

Please anybody search blob converter?

qa-featured

Hello there Timothy, 

I understand that you have been researching for your problem but none of them works for you.

But have you tried the resolution posted in stack overflow for blob to string conversion for oracle?

If not, you may want to check it out and here's the link for the website. You need to put in these following commands :

Select utl_raw. cast_to_varchar2 (dbms_lob. substr (BLOB_FIELD)) from TABLE_WITH_BLOB where ID = '<row id>';

Hope this helps you.

Waall Mike

About Waall Mike
Questions
20
Answers
220
Best Answers
62

I there any all in one Toolbox task manager?

Previous

I want free rpg offline games of 2010.

Next

Related Questions