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';

Dig Deeper on Oracle and SQL

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close