-- try it select column_name from user_tab_cols where table_name = 'TEST' minus select column_name from user_tab_cols where table_name = 'TEST1';
-- 自已体会一下。 select column_name,'TEST' from (select column_name from user_tab_cols where table_name = 'TEST' minus select column_name from user_tab_cols where table_name = 'TEST1') UNION ALL select column_name,'TEST1' FROM (select column_name from user_tab_cols where table_name = 'TEST1' minus select column_name from user_tab_cols where table_name = 'TEST')
select column_name from user_tab_cols where table_name = 'TEST'
minus
select column_name from user_tab_cols where table_name = 'TEST1';
select column_name,'TEST'
from (select column_name from user_tab_cols where table_name = 'TEST'
minus
select column_name from user_tab_cols where table_name = 'TEST1')
UNION ALL
select column_name,'TEST1'
FROM (select column_name from user_tab_cols where table_name = 'TEST1'
minus
select column_name from user_tab_cols where table_name = 'TEST')