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 (20), 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 1="It is" and String 2= "Spring
Break"
**Take a screenshot of the output.
**Type the command "show function status".
", and screenshot the output for the first 6 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!