Oracle字符串拆分
例如:拆分aaa,bbb,ccc
SELECT
regexp_substr('aaa,bbb,ccc', '[^,]+', 1, LEVEL)
FROM
dual
CONNECT BY
LEVEL <= LENGTH('aaa,bbb,ccc')-LENGTH(REPLACE('aaa,bbb,ccc', ','))+ 1;
输出结果:
來自这篇文章 Oracle字符串拆分
Oracle 截取字符串
SELECT WAREHOUSE_NAM,
substr(WAREHOUSE_NAM,1,instr(WAREHOUSE_NAM,'-')-1) 前,
substr(WAREHOUSE_NAM,instr(WAREHOUSE_NAM,'-')+1,length(WAREHOUSE_NAM)-instr(WAREHOUSE_NAM,'-')) 后
FROM HC_STOCK_BP
输出结果: