oracle 字符串超长处理方法

合集 - SQL优化(2)

1.多个分隔符字符串拆分2023-08-30

2.oracle 字符串超长处理方法2023-08-30

收起

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