Finding tables with BLOB field

How to find the tables from a schema which have at least one BLOB field?

    Requires Free Membership to View

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

This was first published in August 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.