SQL/PL

Task A:

-Write a local PL/SQL gluing function that glues two string parameter inputs together with an intervening white space, and returns a single string value from the function.

-Write a local PL/SQL printing procedure that takes a single parameter input and prints the contents with the dbms_output package.

-Write an anonymous PL/SQL block program that declares two local variables in the declaration block, assigns two substitution variables to the locally declared variables in the execution block, and inside the execution block calls the local gluing function with the two local variables as the only call parameter to the printing procedure.

Test Case (SET SERVEROUTPUT ON SIZE UNLIMITED):

-Write a test case for the local gluing function by adding a local lv_results variable in the declaration section, then call the gluing function with the two local variables and assign the value to the third variable. Print the lv_results variables value inside a call to the put_line procedure of the dbms_output package.

-Write a test case for the local printing procedure by calling it with one of the local variables.

-Write a test case by running the anonymous PL/SQL block and, when prompted for the substitution variables, provide values such as Harry and Potter.