14) By using concatenation write a query to return all the departments names and their cities as the following sample:

The department HR is located in New York.

15) Use concatenation and CHR to write a query to return the following result.

Note: Just create dog with CHR in the following phrase.

This dog is friendly!

16) Write a PL/SQL block to return the following result in 2 lines.

CIS-4580

Spring-2023

17) Write a query to return the following result (for the department number less than 40)

statement

--------------------------------------------------------------------------------

The minimum salary in department 30 is 20000.

The minimum salary in department 10 is 30000.

The minimum salary in department 20 is 30000.

18) Use CHR function with Concatenation Operator and write a block to return the following result:

(Fall)

Note: The Word Fall should be in parentheses.

19) Create a program that outputs this message "I will be a PL/SQL expert at the end of this class."

20) Declare variables and create a block to format the output with the following result in 3 lines and display blank lines between them:

I am taking CIS-4580.

I am learning PL/SQL.

This is fun.