This page provides exercises and solutions to help you practice SQL Scalar Functions. These exercises are based on the HR database, and may be performed online or by running the sample schema scripts on your local database server. For additional exercises in other subjects, use this link.
 

String Functions Practice

  1. Display the first name in lower case and last name in upper case, for all employees whose employee number is in the range between 80 and 150.
  2. Display the first name and last name for all employees whose family name is King, perform this exercise with a case-insensitive search (regardless of the capitalization used for the values within last name column).
  3. Generating new email address
    1. For each employee, display the first name, last name, and email address. The email address will be composed from the first letter of first name, concatenated with the three first letters of last name, concatenated with @oracle.com.
    2. For each employee, display the first name, last name, and email address. The email address will be composed from the first letter of first name, concatenated with the three last letters of last name, concatenated with @oracle.com.

Would you like to read more?