Dbms18

DECLARE
percentage NUMBER;
grade VARCHAR2(20);
BEGIN
percentage := &input_percentage;

IF percentage >= 75 THEN
    grade := 'Distinction';
ELSIF percentage >= 60 THEN
    grade := 'First Class';
ELSIF percentage >= 45 THEN
    grade := 'Second Class';
ELSIF percentage >= 40 THEN
    grade := 'Pass Class';
ELSE
    grade := 'Fail';
END IF;

DBMS_OUTPUT.PUT_LINE('Your grade is: ' || grade);

EXCEPTION
WHEN VALUE_ERROR THEN
DBMS_OUTPUT.PUT_LINE('Invalid input. Please enter a numeric value');
END;
/