oracle 字符串超长处理方法
--解决字符串超长的问题
select to_char(teigger)
from (
select
'create or replace '||XMLAGG(XMLPARSE(CONTENT text || '' WELLFORMED) ORDER BY line).GETCLOBVAL() teigger
from all_source
where type='TRIGGER'
--and name ='t_temp_LOG'
AND name in (select a.trigger_name
from all_triggers a
where
1=1 --TRIGGER_NAME like '%t_temp_INSERT'
and table_name='t_temp'
AND TABLE_OWNER='owner')
group by name
)