Select BLOB Data

select substr(utl_raw.cast_to_varchar2(at.column_name), 341, 41) as MSISDN from archive_tbl at where utl_raw.cast_to_varchar2(at.column_name) like '%01287392728%';