When trying to use right click | Export Blobs (Longs,Raws) in the data grid, there is an option to "Export to files named for the value in this column" option. But the drop down list for this, to select the column, is empty (no columns listed). The grid/query returns rows with 8 columns of data of which only 1 is a blob.
Toad not picking up some columns depending on datatype.
WORKAROUND:
Use a column that is of type varchar. Some columns of certain datatypes will not be shown, others will be shown. Test out different datatypes to see which shows up and which works for the table/environment.
STATUS:
Waiting for fix in a future version of Toad for Oracle.