如何从以下格式的 FULL_NAME 列中拆分姓名(LAST_NAME、FIRST_NAME 和 MIDDLE_NAME):
FULL_NAME: BARN,KE ROMAN where FIRST_NAME: KE, MIDDLE_NAME: ROMAN & LAST_NAME: BARN
我能够编写下面的 sql,但是如何添加 MIDDLE_NAME 查询以及如果 MIDDLE_NAME 为空怎么办(例如 FULL_NAME:BARN,KE)
SELECT TRIM (SUBSTR (NAMES, INSTR (NAMES, ',', 1) + 1)) AS FIRST_NAME,
TRIM (SUBSTR (NAMES, 1, INSTR (NAMES, ',', 1) - 1)) AS LAST_NAME
FROM TABLE
非常感谢任何帮助!
Thanks!
SELECT Substr(fullname, 1, Instr(fullname, ' ') - 1) AS First_Name,
Substr(fullname, Instr(fullname, ' ') + 1) AS Last_Name
FROM emp;
SELECT Substr('Amit Chauhan', 1, Instr('Amit Chauhan', ' ') - 1) AS First_Name,
Substr('Amit Chauhan', Instr('Amit Chauhan', ' ') + 1) AS Last_Name
FROM dual;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)