查询包含某个字段的表

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