#1.查询该表所有的字段
SELECT column_name FROM user_tab_columns where table_name = upper('表名');
#2.查询有该字段的表
select * from DBA_TAB_COLUMNS where COLUMN_NAME='字段名';
SELECT column_name FROM user_tab_columns where table_name = upper('表名');
select * from DBA_TAB_COLUMNS where COLUMN_NAME='字段名';