Question
Write a PL/SQL block to perform the following: Declare 4 variables ( grade1, grade2, grade3, grade4 ) and store a grade value in each. The
Write a PL/SQL block to perform the following:
Declare 4 variables ( "grade1", "grade2", "grade3", "grade4" ) and store a grade value in each. The maximum possible grade is "100".
Declare "avgGrade" variable (should store avg to 1 decimal point of precision)
Calculate the Average Grade and store results in "avgGrade"
Display the average grade. For example the output format would be as follows: "The average grade is 75.4 "
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Formal SQL Tuning For Oracle Databases Practical Efficiency Efficient Practice
Authors: Leonid Nossov ,Hanno Ernst ,Victor Chupis
1st Edition
3662570564, 978-3662570562
