Re: Copy Blob data into Varchar2

From: Mladen Gogala <>
Date: Thu, 26 Mar 2020 18:49:49 -0400
Message-ID: <>

Hi Sanjay!

Nothing easier! Extract few LOBs into the OS files, and see the structure with the "vi" editor, "strings" command and see if you can convert it to ASCII text with something like this:

mgogala_at_umajor:~$ which pdftotext
mgogala_at_umajor:~$ which html2text

I don't know what application are you using but if there is an online converter, you should be able to convert it to text file and load the lines into table with sufficiently large VARCHAR2 column.


On 3/25/20 8:54 PM, Sanjay Mishra wrote:
> Mladen
> Yes your point make sense as if data is real binary then select will
> display junk character. This current data is somehow stored by a third
> party application but has all text data. Not sure if this is kept blob
> due to some future requirement.
> Tx
> Sanjay
> --

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Received on Thu Mar 26 2020 - 23:49:49 CET

Original text of this message