Problem solve Get help with specific problems with your technologies, process and projects.

How do you view the BLOB?

How do you view the BLOB?

How do you view the BLOB?

How you view a BLOB value all depends on your application development platform. SQL*Plus will not let you see BLOB...

values since SQL*Plus is a text environment and BLOB values are binary data. Also, the BLOB value could be a sound file, or an MPEG movie. SQL*Plus is not able to play sounds or show movies. As such, Oracle has coded SQL*Plus to not show BLOB values.

This Oracle documentation shows a lot of information on BLOBs. Pay close attention to Chapter 6 as it contains information on how to access BLOBs for your specific development platform.

You may need to register for an account to view the document, but registration is free!

This was last published in May 2006

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.