select distinct substr(substr(xx,0,instr(xx,'where',1,1)-1),15) from
(
select 'select * from ' || table_name || ' where ' || column_name ||
'=''河仓'';' xx
from user_col_comments
)aa where lower(xx) like '%jcxx%'
基础数据XX的样式:select * from jcxx_...... where .....
上面写法可以得到from后where 前的数据。
也欢迎各位提出更精简方法。