JZTXT

oracle 字符串超长处理方法

发布时间 2023-08-30 15:19:49作者: 没有龅牙的兔子

--解决字符串超长的问题
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_EMR_SUCCESS_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
)