Create a "Function" to concatenate the customer's last name and first name to be separated by a comma.

Remember!  A "Function" can have none or many input parameters, but it returns one and only one value.

=

Select “Program Units” and click “create.”

=

Name the function "Full_Name,” then select "Function" and click “OK.”

 

Declare a datatype for the Function return value.

=

Declare a first name and last name input parameters.

Their datatypes should match with the datatype of the firstname and lastname in the customers table.

=

In the PL/SQL body, return the customers’ concatenated name with a syntax error and misspell the return statement.

Only just, to see what type of error messages we get.

=

Write the exception.

In the exception section, do nothing in the case of an exception.

=

Compile the function.

=

Read the error message.

Notice that the pipe line points right to the error.

Everything else in the stored procedure looks OK.

 

Correct the syntax.

=

Compile the function.

Successfully compiled.  Then close the window.

=

Save the function in the database server.

Choose the “Program” option and select the "PL/SQL interpreter"

=

 

Use the select statement to test the function and pass two input parameters to the full_name function from the dummy table.

Make the first parameter "John" and second "Kazerooni".

=

The concatenation was successful.