PL/SQL

-- Finding a column name in all tables

select a.table_name, column_name,DATA_TYPE,DATA_LENGTH from all_tab_columns a,USER_ALL_TABLES u
where a.TABLE_NAME=u.TABLE_NAME
and column_name like '%TXTM%'
order by DATA_LENGTH desc;