Create a package which contains function to ask the user to enter the student’s marks and determine the GRADE according to the following criteria.

 >90 A
>80AND <90 B
>70AND <80 C
>60 AND<70 D
<60 F

PROGRAM:-

CREATE OR REPLACE PACKAGE Checks AS

PROCEDURE marks(mark in INTEGER);

END Checks;

/

CREATE OR REPLACE PACKAGE BODY Checks AS

PROCEDURE marks(mark in Integer) IS

BEGIN

IF( mark >= 90) THEN

dbms_output.put_line('Grade A');

ELSIF(mark >= 80 AND mark < 90) THEN

dbms_output.put_line('Grade B');

ELSIF(mark >= 70 AND mark < 80) THEN

dbms_output.put_line('Grade C');

ELSIF(mark >= 60 AND mark < 70) THEN

dbms_output.put_line('Grade D');

ELSIF(mark < 60) THEN

dbms_output.put_line('Grade F');

END IF;

END marks;

END Checks;

/

EXECUTE checks.marks(43);

EXECUTE checks.marks(89);

Output:-

WHEN MARKS ARE 43 AND 89

WHEN MARKS ARE 73 AND 93