Mostly Making oracle easy, mostly:

In SQL Developer

Working with BLOBs in Oracle SQL Developer Web

December 14, 2020 2 Mins Read

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

A picture of The Blob stored as a BLOB

But, what about in your browser?

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

So far, meh?

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

Some info, how big is it, what kind of file is it?

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

Cool.

What about GIFs?

Animated GIF of viewing an animated GIF when stored as a BLOB in SQL Developer Web

And a PDF?

Check.

And finally some TEXT.

First, we’ll view it as the HTML object.

What if I don’t want the HTML rendered?

It’s just a text file, so…

“Object” => let the browser handle the data via mime type, ‘Text’ => the raw source.

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 –

Open table, browse table.

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

More to come!

Share on Facebook

Author thatjeffsmith

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

1 Comment

houshmand rastin 10 months ago Reply

hi,
very nice, but i dont use sql developer web ,user is ords enable, after login this error show:

An error occurred
Please clear your browser’s temporary files and try again.

why?

Write A Comment Cancel Reply