Question: Write a user input function which uses the CONCAT function. In this function you need to concatenate two strings, character data type such as char
Write a user input function which uses the CONCAT function. In this function you need to concatenate two strings, character data type such as char and put an exclamation point at the end. There must be a space between the words, note there is not a space in the two strings, also the exclamation point is part of the function and not the inputted string. For example, if you input into your function the words What's and up the output would be What's up In other words, the space between your two inputs and the are part of the function and not the inputs.
When completed, use your function with the following: String It is and String "Spring
Break"
Take a screenshot of the output.
Type the command "show function status".
and screenshot the output for the first columns
Db Name, Type, Definer, Modified, Created This will show all of the functions you have created.
Give the SQL query
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
