oracle中姓名取姓氏,Oracle SQL - 解析一個名稱字符串並將其轉換爲第一個姓氏和名字...

有沒有必要創建自己的功能，而且很坦率地說，它似乎浪費了現在可以用已經存在的sql函數很容易地完成這個任務。必須小心處理馬虎數據輸入。

這裏是另一種方式來實現自己的既定目標：

with name_list as

(select ' Parisi, Kenneth R' name from dual)

select name

-- There may be a space after the comma. This will strip an arbitrary

-- amount of whitespace from the first name, so we can easily extract

-- the first initial.

, substr(trim(substr(name, instr(name, ',') + 1)), 1, 1) AS first_init

-- a simple substring function, from the first character until the

-- last character before the comma.

, substr(trim(name), 1, instr(trim(name), ',') - 1) AS last_name

-- put together what we have done above to create the output field

, lower(substr(trim(substr(name, instr(name, ',') + 1)), 1, 1)) ||

lower(substr(trim(name), 1, instr(trim(name), ',') - 1)) AS init_plus_last

from name_list;

HTH， 加布