查询数据库中含clob，blob的表

查询含clob，blob的表
select distinct ('TABLE "' || a.OWNER || '"."' || a.TABLE_NAME || '"')
from sys.all_tab_columns a
where a.OWNER = 'EHL_TOS'--用户名
and a.TABLE_NAME in
(select t.TABLE_NAME
from sys.all_tab_columns t
where t.OWNER = 'EHL_TOS'--用户名
and t.DATA_TYPE in ('CLOB', 'BLOB'))

转载于:https://www.cnblogs.com/wangfg/p/5112474.html