输入banner图图片脚本导航/分类

【oracle】oracle REGEXP_SUBSTR分割字符串

REGEXP_SUBSTR(17,20,23, [^,]+, 1, LEVEL, i) AS STR FROM DUAL CONNECT BY LEVEL <= LENGTH(17,20,23) - LENGTH(REGEXP_REPLACE(17,20,23, ,, ‘‘))+1;

 

 查询结果:

技术分享

 

【oracle】oracle REGEXP_SUBSTR分割字符串

标签:style   nec   from   ora   http   bst   com   color   evel