How to read data from BLOB column ?

select message_data from xxxxx

We cannot see message_data as blob, wondering how we able to see the content ? Thanks.

Research DBMS_LOB, you can start here http://www.psoug.org/reference/dbms_lob.html