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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

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"...

Q:

how to add function to promp user for numeric input only so it doesnt break the code ? import java.util.Scanner; class TestGrade { //main method public static void main (String arg[]) { //declare the...

Q:

Name ID Create a market competitive pay plan for the company named "Tech Experts", which is a software development based company, and taking into consideration the following information. (20 Marks)...

Q:

Whats inside the testinput.dat file: Whats inside the testoutput.txt file:c Testing: Working With File I/O Write a program that reads students' grades from a file and calculates the average with the...

Q:

please help ASAP. This is a virtual box assignment with a vagrant. 0 opcode mnemonic description NOOP / HALT Indicates system halt state 1 LOAD Load AC from memory 2 STORE Store AC to memory 3 JMP...

Q:

C type!!!! They are all different Questions, not just one assignment, they are all independent except for the last one that has 3 parts 1. Write the function prototype for a function called...

Q:

Assembly Language Help. Please any help would be appreciated Programming Assignment 5 (Due Wednesday April 4 at Midnight) In this assignment you will write a program to evaluate a series of...

Q:

This assignment will give you practice with parameters, returning values, and interactive programs. Create a file called Grades named Grades.java, which will be submitted electronically on the course...

Q:

Could you please help complete the following java code. Help is needed where //*** is throughout the code. import java.util.Arrays; import java.util.Random; import java.util.Scanner; // // Project 3...

Q:

this assignment is regarding return the tax of a client by using handy taxassignment. can anyone help me to complete the income section of this assignment, just write the solution in a pdf file?I...

Q:

Matching Type: Choose the descriptor in the dropdown that matches the statement below (5 points). The placement of elements on the page so they are evenly distributed so that one part or section of...

Q:

Solve the systems in Problem graphically and indicate whether each solution region is bounded or unbounded. Find the coordinates of each corner point. 4x + 3y 24 3x + 4y 8 x 0 y 0

Q:

When using a VPN to remotely connect from your home to a server in your office, the tunnel passes throigh the VPN concentrator and is encrypted by the VON ip to the remote server. True or force

Q:

Consider a project with free cash flow in one year of $133,404 or $184,193, with either outcome being equally likely. The initial investment required for the project is $75,000, and the project's...

Q:

(Appendices) PURCHASES, SALES, AND COST OF GOODS SOLD. Printer Supply Company sells computer printers and printer supplies. One of its products is toner cartridges for laser printers. At the...

Q:

(Appendices) PRESENTATION OF SALES REVENUE AND COST OF GOODS SOLD. The accountant for Sneva, Inc., collected the following data for 19x: LO3 REQUIRED: Assume that Sneva uses the periodic system and...

Q:

(Appendices) ADJUSTING ENTRY AND PREPARATION OF FINANCIAL STATEMENTS. Michaels Hardware has the following unadjusted trial balance at the end of 19x3: The following data are also available for...