查询包含某个字段的表

SELECT DISTINCT DT.*
FROM DBA_TABLES DT, DBA_TAB_COLUMNS DTC
WHERE DT.TABLE_NAME = DTC.TABLE_NAME
AND DTC.COLUMN_NAME = '&COLUMN_NAME'
AND dt.NUM_ROWS > 0;