Working with BLOBs in Oracle SQL Developer Web

SQL Developer Desktop allows you to load, download, view, and update BLOBs in your Oracle Database tables.

But, what about in your browser?

Let’s browse a table (via Query) in SQL Developer Web, version 20.3.

For the ‘fun’ stuff, see the pencil icons on the (BLOB) cells in the data grid.

OK, so if we know it’s a picture, can we see the picture?

What about GIFs?

And a PDF?

And finally some TEXT.

What if I don’t want the HTML rendered?

It’s just a text file, so…

What about changing/inserting the BLOBs?

Read/write GRIDs are on on our product roadmap for 2021.

However, for version 20.4, we will have DATA tab for tables and views, so you can browse the tables without writing the SELECT * FROMs…

Sneak Peek of 20.4 and TABLE Viewers –

Not shown, the Filtering feature added for tables/views data grids.

More to come!