Avatar of shragi
Flag for India

asked on 

oracle sql string split

Hi - I have a string like "LNAME, FNAME MNAME SURNAME"
I am trying to write query in oracle to get just the FNAME and LNAME excluding others.

1) data is comma seperated
2) the data before comma is LNAME and first word after comma is FNAME.

How can I get that.

DatabasesOracle DatabaseSQL

Avatar of undefined
Last Comment

8/22/2022 - Mon