For this query there are many first and last names with some having middle initials with a '.' at the end.

Current result:
Hong, Amy L.
Jackson, Yuri K.
Nguyen, Roy


Desired:
Amy Hong
Yuri Jackson
Roy Nguyen

How can I achieve this with SQL Plus?
Thanks.