I have talked about how to preview BLOBs (Binary Large Objects) as pictures…

A picture of The Blob stored as a BLOB
A picture of The Blob stored as a BLOB

But someone on Stackoverflow asked how to read a BLOB value if it had text.

So I spooled the content of my EMPLOYEES table to a txt file, as CSV, and then loaded that to a table as a BLOB.

Then I browsed the table, double-clicked the cell…

Check the 'text' box
Check the ‘text’ box

and voila, the data being stored…

No need to write a function to read the data in your query..unless you want to, of course.
No need to write a function to read the data in your query..unless you want to, of course.

Other BLOB posts:

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

1 Comment

Write A Comment