SELECT column_name FROM all_tab_cols WHERE table_name = ‘TEST_ZHOUPANCHAO‘ intersect SELECT column_name FROM all_tab_cols WHERE table_name = ‘TEST_ZHOU‘
找两个表中相同的列名
原文:http://www.cnblogs.com/feifeishi/p/6837067.html