承接网站怎么做,网站建设塞西,怎么把自己做的网站放在,一门app开发平台您已经提供了数据样本,说明这是一行,但已将其显示为两个不同的行.所以这个例子基于你的话.-- Sample of data from your question extra row for the sake of demonstration-- id column is added to distinguish the rows(I assume you have one)with t1(id, col) as(select …您已经提供了数据样本,说明这是一行,但已将其显示为两个不同的行.所以这个例子基于你的话.-- Sample of data from your question extra row for the sake of demonstration-- id column is added to distinguish the rows(I assume you have one)with t1(id, col) as(select 1, ^FO360,065^AEN,25,10^FD{CUSTOMERS1.CUST_NAME}^FS^FO360,095^AAN,15,12^FD{CUSTOMERS1.CUST_ADDR1}^FS from dual union allselect 2, ^FO360,065^AEN,25,10^FD{CUSTOMERS2.CUST_NAME}^FS^FO360,095^AAN,15,12^FD{CUSTOMERS2.CUST_ADDR2}^FS from dual),cnt(c) as(select levelfrom (select max(regexp_count(col, {\w.\w})) as o_cfrom t1) zconnect by level z.o_c)select t1.id, listagg(regexp_substr(t1.col, {\w.\w}, 1, cnt.c)) within group(order by t1.id) resfrom t1cross join cntgroup by t1.id结果ID RES---------------------------------------------------------1 {CUSTOMERS1.CUST_ADDR1}{CUSTOMERS1.CUST_NAME}2 {CUSTOMERS2.CUST_ADDR2}{CUSTOMERS2.CUST_NAME}根据问题的a_horse_with_no_name comment,实际上,更换其他与模式不匹配的内容要简单得多.这是一个例子with t1(col) as(select ^FO360,065^AEN,25,10^FD{CUSTOMERS.CUST_NAME}^FS^FO360,095^AAN,15,12^FD{CUSTOMERS.CUST_ADDR1}^FS from dual)select regexp_replace(t1.col, ({\w.\w})|., \1) resfrom t1结果RES-------------------------------------------{CUSTOMERS.CUST_NAME}{CUSTOMERS.CUST_ADDR1}
