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.