Ask the Expert

How do you view the BLOB?

How do you view the BLOB?

    Requires Free Membership to View

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 first published in May 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

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

Your password has been sent to: