1.函数嵌套，获取两个‘|’之间的数据
select substr(t.org_business_order_num,instr(t.org_business_order_num,'|',1,2)+1,instr(t.org_business_order_num,'|',1,3)-instr(t.org_business_order_num,'|',1,2)-1) from dual t
扫一扫
到【灌水乐园】发言
1.函数嵌套，获取两个‘|’之间的数据
select substr(t.org_business_order_num,instr(t.org_business_order_num,'|',1,2)+1,instr(t.org_business_order_num,'|',1,3)-instr(t.org_business_order_num,'|',1,2)-1) from dual t
