codemaniacstudio

Write a program to enter marks of five subjects and calculate total, average and percentage in PLSQL block.

Practical Practice 16

Oracle Practice

Write a program to enter marks of five subjects and calculate total, average and percentage in PLSQL block.

Write a program to enter marks of five subjects and calculate total, average and percentage in PLSQL block.

SOLUTION

--Static code

set serveroutput on;
DECLARE
   rno number := 5;
   name varchar2(100) :='abc';
   marks1 NUMBER := 50; 
   marks2 NUMBER := 80; 
   marks3 NUMBER := 40; 
   marks4 NUMBER := 70; 
   marks5 NUMBER := 60; 
   total NUMBER;  
   percentage NUMBER; 
BEGIN
   
total := marks1 + marks2 + marks3 + marks4 + marks5;
percentage := total/5;

   DBMS_OUTPUT.PUT_LINE('Roll number: ' || rno);
   DBMS_OUTPUT.PUT_LINE('Name : ' || name);
   DBMS_OUTPUT.PUT_LINE('Total Marks: ' || total);
   DBMS_OUTPUT.PUT_LINE('Percentage: ' || percentage || '%');
END;
/
    


--Dynamic code 
set serveroutput on;
DECLARE
   rno number := &rno;
   name varchar2(100) := '&name';
   marks1 NUMBER := &marks1; 
   marks2 NUMBER := &marks2; 
   marks3 NUMBER := &marks3; 
   marks4 NUMBER := &marks4; 
   marks5 NUMBER := &marks5; 
   total NUMBER;  
   percentage NUMBER; 
BEGIN
   
total := marks1 + marks2 + marks3 + marks4 + marks5;
percentage := total/5;

   DBMS_OUTPUT.PUT_LINE('Roll number: ' || rno);
   DBMS_OUTPUT.PUT_LINE('Name : ' || name);
   DBMS_OUTPUT.PUT_LINE('Total Marks: ' || total);
   DBMS_OUTPUT.PUT_LINE('Percentage: ' || percentage || '%');
END;
/


TRY IT YOURSELF

Exit mobile version