SQL using Oracle. The task is to remove suffix from last name column (e.g. Smith Sr. or Stevens Jr.) and put into the preexisting suffix column in the DB. Final result needs to be in the last name column: Smith or Stevens. In the suffix column: Sr. or Jr. I am trying to do this by creating a temp_table and regexp to populate this. Then update my preexisting table using a while loop & the temp_table data.