Question
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
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 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
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