Answer to Question #258939 in Databases | SQL | Oracle | MS Access for Tarurendra Kushwah

Question

Write a PL/SQL program to display the description against a grade according to the marks achieved by students in their final exams.

Answer 1

DECLARE
    grade CHAR(1);
  BEGIN
    
    grade := '&new_grd';
  CASE grade 
    WHEN 'A' THEN dbms_output.Put_line('Outstanding');
    WHEN 'B' THEN dbms_output.Put_line(' Excellent');
    WHEN 'C' THEN dbms_output.Put_line('Very Good');
    WHEN 'D' THEN dbms_output. Put_line('Average');
    WHEN 'F' THEN dbms_output.Put_line('Poor');
    ELSE dbms_output.Put_line('Invalid Grade.');
  END CASE;	
  END;