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;
/

--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; /