Sumit Prakash
asked on
How to convert a blob into string. I have a command but it gives only some part of text from blob
Hello Expert,
I have below command , it is giving only some part of BLOB. Can you please suggest some modification through which I get all the text from the blob (output).
select utl_raw.cast_to_varchar2(d bms_lob.su bstr(RECEI VE_DATA,20 00,1))
from CWMESSAGELOG where USER_DATA3= '10099546';
A swift response will be much more appreciated.
I have below command , it is giving only some part of BLOB. Can you please suggest some modification through which I get all the text from the blob (output).
select utl_raw.cast_to_varchar2(d
from CWMESSAGELOG where USER_DATA3= '10099546';
A swift response will be much more appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER