SQL Loader to split a string base on certain requirements into a new field

39 Views Asked by John Al At 16 May 2023 at 14:54

I have a flat file that contains a list of people's name. I need to split the last name into a new column when executing sql loader.

Here's the tricky part. I need to split out the surename if it's uppercase base on the following scenarios.

There are 0 best solutions below