Oracle Blob Editor

RazorSQL contains a tool that allows users to work with Oracle blobs. Options include the ability to edit blob data, save blob data to a file, and view blob data as an image.

To launch the Oracle blob editor, connect to Oracle and then view the contents of a table that contains a blob column by using the view contents option of the database browser, or by running a select query against the table. Once the results are displayed in the query results section, the right-click / context menu of a results cell that contains blob data will contain options called "Binary Data Editor" and "View as Image".

To edit the blob data or save the blob data to a file, the "Binary Data Editor" option can be selected. Note, this option is only available for tables that have a primary key. After selecting the binary data editor menu item, the binary data editor window will display. There are options for saving the binary data to a file, updating the binary data from a file, viewing the data as an image, or editing the data as character data after specifying a character encoding.

To insert binary data into a blob column in a new row in a database table, a row should first be inserted containing either a null value for the blob or a dummy value. After the new row is inserted, the user can query the table using RazorSQL and launch the binary data editor.