字符串拆分

SAFETY_CONTROL_SITUATION_0604#SAFETY_CONTROL_SITUATION_0605#SAFETY_CONTROL_SITUATION_0606#SAFETY_CONTROL_SITUATION_0608#SAFETY_CONTROL_SITUATION_0609#SAFETY_CONTROL_SITUATION_0610#SAFETY_CONTROL_SITUATION_0611#SAFETY_CONTROL_SITUATION_0612#SAFETY_CONTROL_SITUATION_0613

通过#拆分为多行，如何实现？

你这个是什么使用场景？如果单纯想实现你这个可以在ETL里面先根据#拆成列，然后列转成行

百度一下 你对应数据库的拆分语句，

with recursive 构造序列(n ) as
( select 1   
union all
select n+1 from 构造序列
where n <1000
)
select  substring_index(substring_index(  p,'#',n ),'#',-1) from 构造序列 x
,
(select
'SAFETY_CONTROL_SITUATION_0604#SAFETY_CONTROL_SITUATION_0605#SAFETY_CONTROL_SITUATION_0606#SAFETY_CONTROL_SITUATION_0608#SAFETY_CONTROL_SITUATION_0609#SAFETY_CONTROL_SITUATION_0610#SAFETY_CONTROL_SITUATION_0611#SAFETY_CONTROL_SITUATION_0612#SAFETY_CONTROL_SITUATION_0613'
as p) y  
where n<=length(p)- length (replace(p,'#','')) +1