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‘