Hi All,
I have a requirement where we need to extract text from a BLOB field and display it using SQL query.
I have tried the below ones but no luck....
Actual Data::
select SCOPE_BIN from CUBE_SCOPE;
SCOPE_BIN
---------------------
(BLOB)
I have used the below query to read the text from BLOB field
select utl_raw.cast_to_varchar2(dbms_lob.substr(SCOPE_BIN)) from CUBE_SCOPE;
but it is giving the output in unreadable format.
Can any one please help me on this this is very urgent
Thanks you so much for your responses in advance
Thanks,
Rajesh