If you have a column with full name data and you want to split this data, you can use below function to split operation.
Split Name ve Surname
Table : test
Data1 : Emin Fatih Acar
Data2 : Fatih AcarSQL> select fullname,
substr(fullname,0,instr(fullname,’ ‘,Instr(fullname,’ ‘,-1))-1) name,
substr(fullname,Instr(fullname,’ ‘,-1)+1) surname
from test;Result:
Data1
name : Emin Fatih
surname : AcarData2
name : Fatih
surname : Acar
Split Name,Midname and Surname
SQL> select fullname,
substr(fullname,0,instr(fullname,’ ‘)-1) name,
substr(fullname,instr(fullname,’ ‘)+1,Instr(fullname,’ ‘,-1,1)- instr(fullname,’ ‘)-1) midname,
substr(fullname,Instr(fullname,’ ‘,-1)+1) surname,
from test;Result:
Data1
name : Emin
midname : Fatih
surname : AcarData2
name : Fatih
midname : null
surname : Acar