The task is to remove suffix from last name column

Assignment Help Computer Engineering

Reference no: EM132135996

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.

Reference no: EM132135996

Questions Cloud

What are its unique structural and behavioral concepts : What are its unique structural and behavioral concepts? What are its most frequently used methods?

Write a main function that declares an array of 100 doubles : In a for loop, assign each of the doubles a random number between 0.50 and 50.00. Here's how. array[i] = (double) (rand() % 100 + 1) / 2.0;

Determine the internal rate of return for a project : Determine the internal rate of return for a project that costs -$149,500 and would yield after-tax cash flows of $23,000 the first year

What was the strategy used in the case : What improvements could you offer as an IT leader managing the strategy for the situation covered by the case?

The task is to remove suffix from last name column : 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.

Does there always exist a perfect matching with no strong : Does there always exist a perfect matching with no strong instability? Does there always exist a perfect matching with no weak instability?

Eliminate the problem and turn the initiative into a success : Explore and elaborate on this reason for failure. Provide a solution that will eliminate the problem and turn the initiative into a success

Write a program that lets the user enter the initial height : Write a program that lets the user enter the initial height of the ball and the number of times the ball is allowed to continue bouncing.

Write function called closer_root that takes two numbers : Write another function called closer_root that takes two real numbers and returns the one whose square root is closer to the number 10.

User Account

All Pages