textual contents from BLOB in Oracle SQL

textual contents from BLOB in Oracle SQL

with unzipped_text as (
select
my_id
,utl_compress.lz_uncompress(my_compressed_blob) as my_blob
from my_table
where my_id=’MY_ID’
)
select * from unzipped_text
where dbms_lob.instr(my_blob, utl_raw.cast_to_raw(‘MY_SEARCH_STRING’))>0;

http://stackoverflow.com/questions/828650/how-do-i-get-textual-contents-from-blob-in-oracle-sql

Advertisements