Getting a textual representation from an Oracle BLOB

1149185 pts.
Tags:
BLOB
Oracle
I've been trying to see, from inside my SQL console, what's inside an Oracle BLOB. I already know that it contains a large body of text and I need to see it. But my query only shows that there's a BLOB in the field. Here's the query:
select BLOB_FIELD from TABLE_WITH_BLOB where ID = '';
And this is what I'm getting:
   BLOB_FIELD
    -----------------------
    oracle.sql.BLOB@1c4ada9
So can I make my query turn the BLOG into a textual representation? Appreciate any help.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: