Question: Write a PL/SQL block that allows the user to input an ID. Then the program finds the maximum mark among the marks for that student

Write a PL/SQL block that allows the user to input an ID. Then the program finds the maximum mark among the marks for that student in the MARKS table. Use exception handling to handle the following predefined exceptions: value error, no data found, and other exceptions.

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!

Question 1 Write a PL/SQL block that allows the user to input his/her name and print it with the string "Your Name is: .'. Question 2 Write a PL/SQL block that allows the user to input a sub-total...

Write a PL/SQL block that allows the user to enter student id, and then the program prints all information about the student with the given id from the STUDENT table. Use exception handling to handle...

1411116 - Programming I Assignment #3 Due Date: November 30, 2016 Submission Instructions: Submit your assignment on the blackboard link, corresponding to your Section: Please follow the following...

This is one whole C program for a tic tac toe game. I have included questions in the pictures and in the text too. So, if you don't understand what's written in pictures you can look at the text....

Suppose you have the following EMPLOYEES, CITY and EMPSAL tables. [7 marks] EMPLOYEES EID Fams 55 Asad 36 B 57 All 58 Mohmed M 59 M 60 Amal F CITY CITYID EGender ECTTV Beal 400 M M M CITYNAME IZKI...

plsql Section (1) - Writing the Program I 10 Marks) Direction: Use the table below for your reference in answering Question 1 and 2. Table Name: Product PID PNAME 1 N Computer Printer Laptop Keyboard...

Information Technology 1. Introduction Aim In this assignment, you'll build your own simple 1/0 library called myio, vaguely similar to stdio.h, by writing your own functions for performing various...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

How close to ideal gas behavior (find Z) is ammonia at saturated vapor, 100 kPa? How about saturated vapor at 2000 kPa?

In a spring controlled governor, the controlling force curve is a straight line. Balls are 500 mm apart when the controlling force is 1800 N and they are 300 mm apart when the force is 1000 N. To...

E20.11 (LO 3) (Lessor Entries with Bargain Purchase Option) A lease agreement between Mooney Leasing and Choi Group is described in E20.10. Instructions Refer to the data in E20.10 and do the...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Know the communications mix elements that originate from outside the firm.

Know the communications mix elements available via service delivery channels.

Know the theoretical foundation from environ-mental psychology that helps us understand how customers and employees respond to service environments.