SQL_ORACLE速记---比较两张表的数据类型和数据长度是否一致；导出数据表类型和长度

SELECT * FROM (SELECT COLUMN_NAME,DATA_LENGTH FROM USER_TAB_COLUMNS WHERE TABLE_NAME='REP_APPLY_INQ_ITEM') T1 INNER JOIN(
SELECT COLUMN_NAME,DATA_LENGTH FROM USER_TAB_COLUMNS WHERE TABLE_NAME='REP_INQUIRY_ITEM_VENDOR') T2 ON T1.COLUMN_NAME=T2.COLUMN_NAME;