查询包含某个字段的表 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; PLSQL_CODE 2023-10-17 54 点赞 0 评论 81 浏览
