SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Name Parsing

User_G7LLINov 7 2022

Hi
My oracle version is Oracle 12.1.2

I am trying to parse full name listed in the below form:
Roberson, Tam
Wells,Bob K
Moore, Gary Jerome

I need output to split this fields as follows:
Last_name First_Name Middle_name
Roberson Tam
Wells Bob K
Moore Gary Jerome
Any help is greatly appreciated

Sincerely
JTx

This post has been answered by mathguy on Nov 7 2022

Jump to Answer

Added on Nov 7 2022

5 comments

469 views

2 mentions