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!

thatjeffsmith
Author

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

  1. Avatar

    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

RSS
Follow by Email
LinkedIn
Share