select column_name,table_name from all_col_comments where owner ='SCOTT' AND column_name ='EMPNO' 或者 select column_name,table_name from user_col_comments where column_name ='EMPNO'追问
琢磨一下啊,谢谢啦
第2个回答 2011-09-06
SELECT t.TABLE_NAME FROM cols t WHERE t.COLUMN_NAME = 字段名