第1个回答 2016-08-30
SELECT b.column_name
FROM dba_tables a JOIN dba_tab_columns b
ON a.table_name = b.table_name
WHERE a.table_name IN ('TABLE1','TABLE2')
GROUP BY b.COLUMN_NAME
HAVING COUNT(b.column_name)>1本回答被提问者和网友采纳
FROM dba_tables a JOIN dba_tab_columns b
ON a.table_name = b.table_name
WHERE a.table_name IN ('TABLE1','TABLE2')
GROUP BY b.COLUMN_NAME
HAVING COUNT(b.column_name)>1本回答被提问者和网友采纳
相似回答
