Computer scienceFundamentalsSQL and DatabasesDBMSMySQLDB objects

User-defined Functions

User-defined function missing code

Report a typo

We have a user-defined SQL function called ConcatenateNames that takes two parameters: first_name (VARCHAR) and last_name (VARCHAR) and returns the full_name as a single string.

CREATE FUNCTION ConcatenateNames(first_name VARCHAR(50), last_name VARCHAR(50))
RETURNS VARCHAR(100)
BEGIN
    DECLARE full_name VARCHAR(100);
    MISSING CODE
    RETURN full_name;
END;

Please choose the correct code line for the MISSING CODE section:

Select one option from the list

RETURN full_name = CONCAT(first_name, ' ', last_name);

INSERT full_name = CONCAT(first_name, ' ', last_name);

SELECT full_name = CONCAT(first_name, ' ', last_name);

SET full_name = CONCAT(first_name, ' ', last_name);

___

Create a free account to access the full topic