Please create the program in apex.oracle database, not copy-paste from other wrong program solution PL/SQL in ORACLE

Please create the program in apex.oracle database, not copy-paste from other wrong program solution

 

Transcribed Image Text:

PL/SQL in ORACLE APEX program Need the following PL/SQL function in Oracle APEX: 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: >= 60 F: <60 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 PL/SQL in ORACLE APEX program Need the following PL/SQL function in Oracle APEX: 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: >= 60 F: <60 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