Alex wrote an entry on displaying images stored as a BLOB in the database here. Since PL/SQL Developer is my (and his) favorite editor, I figured I would do the same he did, but this time using PL/SQL Developer.
I will use the same steps.
- Create a table to store the image in
- Upload an Image
- Retrieve the data from the table
- Click the ‘…’ button in the SQL-Window
(note that PL/SQL Developer automatically ‘sees’ that an image should be displayed)
- PL/SQL Developer’s Command window also doesn’t throw an error, but just displays the word <BLOB>.
And that’s it. PL/SQL Developer can do the same thing. Not that I expected differently though.