Oracle 查找带有CLOB字段的所有表

SELECT
T.COLUMN_NAME,
DATA_TYPE,
TABLE_NAME
FROM USER_TAB_COLUMNS T
WHERE DATA_TYPE = 'CLOB'

原文地址:https://www.cnblogs.com/hongwei2085/p/12508374.html