拆分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 ENNAMEFROM T_DICT TWHERE T.DICT_CODE = 'NATION'AND T.RANK = '1'FOR UPDATE