Problem solve
Get help with specific problems with your technologies, process and projects.
Finding tables with BLOB field
How to find the tables from a schema which have at least one BLOB field?
How to find the tables from a schema which have at least one BLOB field?
A simple query from DBA_TAB_COLUMNS will do the trick:
SELECT owner,table_name,column_name FROM dba_tab_columns WHERE data_type='BLOB';
