oracle比较两个表字段,比较oracle表字段是否一致

SELECT M.OWNER

,M.TABLE_NAME

,M.COLUMN_ID

,M.COLUMN_NAME

,M.DATA_TYPE

,M.DATA_LENGTH

,N.OWNER

,N.TABLE_NAME

,N.COLUMN_ID

,N.COLUMN_NAME

,N.DATA_TYPE

,N.DATA_LENGTH

FROM

(

SELECT OWNER

,TABLE_NAME

,COLUMN_ID

,COLUMN_NAME

,DATA_TYPE

,DATA_LENGTH

FROM DBA_TAB_COLUMNS

WHERE OWNER='TRADE'

AND TABLE_NAME='THISBANKREALDEAL'

) M LEFT JOIN

(

SELECT OWNER

,TABLE_NAME

,COLUMN_ID

,COLUMN_NAME

,DATA_TYPE

,DATA_LENGTH

FROM DBA_TAB_COLUMNS

WHERE OWNER='TRADE'

AND TABLE_NAME= 'TBANKREALDEAL'

) N ON M.COLUMN_ID =N.COLUMN_ID

AND M.COLUMN_NAME = N.COLUMN_NAME

AND M.DATA_TYPE = N.DATA_TYPE

AND M.DATA_LENGTH= N.DATA_LENGTH

ORDER BY M.TABLE_NAME, M.COLUMN_ID;