拆分NAME字段 中文与英文
SQL:
SELECT T.ID,
NAME,
SUBSTR(NAME,
0,
INSTR(NAME, REGEXP_SUBSTR(NAME, '[\u4e00-\u9fa5]', 1), 1, 1) - 1) AS ZNNAME,
SUBSTR(NAME,
INSTR(NAME, REGEXP_SUBSTR(NAME, '[\u4e00-\u9fa5]', 1), 1, 1)) AS ENNAME
FROM T_DICT T
WHERE T.DICT_CODE = 'NATION'
AND T.RANK = '1'
FOR UPDATE