Re: Copy Blob data into Varchar2

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
/usr/bin/pdftotext
mgogala_at_umajor:~$ which html2text
/usr/bin/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.

Regards

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

--
http://www.freelists.org/webpage/oracle-l