Question: Write a procedure that will accept a deptartment_id value and a gender value and total_std as parameters and return the the total number of students

Write a procedure that will accept a deptartment_id value and a gender value and total_std as parameters and return the the total number of students with the given gender in that department. The following conditions are to be treated as exceptions: - Handle a relevant named exception by displaying a proper message - If the gender parameter is not ' f ' or ' m '. display 'The value is invalid" - Handle the deadlock exception with the code ORA-060 by displaying "deadlock detected

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!

Assignment 5 Write the solution in a Notepad or Word file and upload it. Department(department_id, name, no_of_courses); student(std_id, name, cpga, gender, department_id) Write a procedure that will...

Code the following using python idle and be sure not to use the constructs in the prohibited list unless specified in the question. Note: 0 is neither positive or negative, so if a function requires...

Project(Pno, title, budget, deptno, rating) Department(Deptno, name, no_of_projects); Emp(empno, first_name, last_name, salary, gender, job_title) Write a function called count_by_gender that will...

1. A player throws a fair die and simultaneously flips a fair coin. If the coin lands heads, then she wins twice, and if tails, then one-half of the value that appears on the die. Determine her...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

CSE Programming & Algorithms for Engineers Spring 2018 Programming Assignment 5: Putting it all together 1 Setting up the Programming Environment 1. Create a new directory (folder) called hw5 and...

Python and most Python libraries are free to download or use, though many users use Python through a paid service. Paid services help IT organizations manage the risks associated with the use of...

Exercises Chapter 2 2.1 Marginal and conditional probability: The social mobility data from Section 2.5 gives a joint probability distribution on (Y1 , Y2 )= (father's occupation, son's occupation)....

C++ Program: Write a program for playing the game of NIM. Our version of the game starts with up to 20 pegs and up to 10 discs in each peg. Two players take turns removing discs from the pegs. On a...

Write a program for playing a variation of the Subtraction game called the game of NIM. Our version of the game starts with up to 15 rods and up to 10 objects in each rod. Two players take turns...

Ski-YA! is a Colorado-based company that sells high-performance ski equipment. When it comes to the serious business of sliding downhill, the Ski-YA! dudes of Colorado don't trouble themselves with...

Oriole Company has current assets of $1510000 and current liabilities of $650000. If they issue $217000 of new stock what will their new current ratio be? 2.7:1 2.32:1 20:1 1.8:1

Joe is a small investor who owns 1 0 0 shares in a stock mutual fund. When the 1 0 0 shares increase in market value, the return to Joe is referred to as _ _ _ _ _ _ .

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

2. List the advantages of listening well

3. Make a list of all the places where you have lived or traveled. (Remember, this does not just mean travel to foreign countries. Think about trips to other neighborhoods in your city or areas of...

5. Do a little virtual shopping in the toy department of an online retailer, and use the search options to see what kinds of toys the retailer suggests for girls versus boys. What do these...