select table_name  from DBA_TAB_COLUMNS where COLUMN_NAME='字段名';


字段名需要大写