How to get the text file from blob, I tried using :
SELECT UTL_I18N.RAW_TO_CHAR(dbms_lob.substr(BLOB_FILE),'AL32UTF8')
FROM TABLE;
Also I tried :
SELECT utl_raw.cast_to_varchar2(dbms_lob.substr(BLOB_FILE))
FROM TABLE
But getting values like this :
xœXÛrÛ6}×LÿAõ;Ã8íC&¡Ò€liª›EÉžN&£Èµ„š"TŽ¿ï„x!'¶°ç,€åb±`yN¶àŒÂ/}ϹüôLJÆß_{݇þuoB÷à<
How can we convert blob file to text?