1. Create a function called convert_numeric_grade that converts a numeric grade to a letter grade. Use...

 

 

Transcribed Image Text:

1. Create a function called convert_numeric_grade that converts a numeric grade to a letter grade. Use a CASE structure. Accept a numeric grade as the input parameter and return a letter grade. Use the following rules: A: >= 90 B: >= 80 C: >= 70 D: F: >= 60 <60 2. Create an anonymous block that invokes convert_numeric_grade. Prompt for the numeric grade and pass as a parameter to convert_numeric_grade. Return the letter grade and output as shown below. Input: :ENTER_NUMERIC_GRADE 75 Output: Numeric grade: 75 Letter grade: C Exercise 2: 1. GET_FULL_NAMEfunction Create a function called get_full_name Pass the student number as a parameter to get_full_name Access the STUDENTS table and return the full name. Example "Joe Smith" Include an EXCEPTION section to check for NO_DATA_FOUND. If the NO_DATA_FOUND error occurs, RETURN a NULL value 2. Create an anonymous block that invokes get_full_name Prompt for the student id and pass as a parameter to get_full_name Return the student's full name and output as shown below . If the student is not found, NULL is returned from the function If NULL is returned, do not output the full name Instead output a message indicating the student was not found Also, include a catch-all handler that displays the error code and error message. 1. Create a function called convert_numeric_grade that converts a numeric grade to a letter grade. Use a CASE structure. Accept a numeric grade as the input parameter and return a letter grade. Use the following rules: A: >= 90 B: >= 80 C: >= 70 D: F: >= 60 <60 2. Create an anonymous block that invokes convert_numeric_grade. Prompt for the numeric grade and pass as a parameter to convert_numeric_grade. Return the letter grade and output as shown below. Input: :ENTER_NUMERIC_GRADE 75 Output: Numeric grade: 75 Letter grade: C Exercise 2: 1. GET_FULL_NAMEfunction Create a function called get_full_name Pass the student number as a parameter to get_full_name Access the STUDENTS table and return the full name. Example "Joe Smith" Include an EXCEPTION section to check for NO_DATA_FOUND. If the NO_DATA_FOUND error occurs, RETURN a NULL value 2. Create an anonymous block that invokes get_full_name Prompt for the student id and pass as a parameter to get_full_name Return the student's full name and output as shown below . If the student is not found, NULL is returned from the function If NULL is returned, do not output the full name Instead output a message indicating the student was not found Also, include a catch-all handler that displays the error code and error message.