oracle 根据字段名查表名

select table_name from dba_tab_cols where column_name='COLNAME';

select table_name from user_tab_cols where column_name='COLNAME';