Oracle 正则表达式 分割字符串
时间:2021-07-01 10:21:17
帮助过:19人阅读
(inData, ‘[^|]+‘, 1,1) into 用户ID FROM DUAL;
SELECT
REGEXP_SUBSTR (inData, ‘[^|]+‘, 1,2) into 用户姓名 FROM DUAL;
SELECT
REGEXP_SUBSTR (inData, ‘[^|]+‘, 1,3) into 性别 FROM DUAL;
Oracle 正则表达式 分割字符串
标签:regex 表达 用户id substr style rac reg from into