oracle中,根据字段名查找表名
记录一下:
SELECT table_name FROM USER_TAB_COLUMNS WHERE column_name = '字段名';
SELECT table_name FROM ALL_TAB_COLUMNS WHERE column_name = '字段名';
oracle中,根据字段名查找表名
记录一下:
SELECT table_name FROM USER_TAB_COLUMNS WHERE column_name = '字段名';
SELECT table_name FROM ALL_TAB_COLUMNS WHERE column_name = '字段名';