Viewing BLOB/CLOB Data
This feature provides a mechanism to view images, audio, video, or other binary format.
Perform the following steps to view BLOB/CLOB data:
1 Establish a connection to the desired database. For more information, see “Establishing a Database Connection.”
2 Click the Query tab.
3 Run an existing query, or create a new query that fetches a binary or large text from the database and click the play icon.
4 In the Resultset window locate the text in green (indicating long data), and click the zoom icon to display the object:
If the object is a text object, the following information displays in the Zoomed data window:
Click the Rich Text tab to view the formatted text object:
If the object is an image, click the Image tab to view the image:
5 Click Close to close the Zoomed data window.
Note: If the binary object is not a rich text or image object and is, for example, a Microsoft® Word® document or an Microsoft® Excel® spreadsheet, click the Other tab to select the appropriate application to view the object, and then click Launch Application:
If your desired application is not listed, select <<Custom>> and specify the extension for your file. For example, if you have an AutoCad diagram saved in the database specify DWG as the file extension.