SQL Developer and BLOBs
SQL Developer is a very complementary tool to Apex.
Although, you can do all basic SQL stuff via the SQL Workshop in Application Express, sometimes you need a more powerful tool like SQL Developer, especially when you really need to ‘develop’ in SQL and PL/SQL.
One of the SQL features I like about SQL Developer is the possibility to look at the content of a BLOB column.
This feature was very useful during my quest on the content of the flows-files table. And I don’t think other tools like TOAD, SQL Navigator, PL/SQL Developer has those possibilities …
Just by clicking on the blob-column in the result grid, a popup window is opened where you can specify that you want to see the content as text or image.
When this column contains plain text, there is no problem at all to have a look at the content. The following example opens a tab-delimited file.
SQL Developer can even visualize binary images (gif, jpeg, bmp). Very handy …