假设表1位table1 ,如裤表2位table2 select a.colfrom (select column_name col from user_tab_columns where table_name = 'table1') a ,(select column_name col from user_tab_columns where table_name = 'table2') bwhere a.col = b.col这样就可以查询出游橡改两神判个表得相同字段了