Question: Create a database package specification and body called students which contains a. getNextStudentId function which return the next available studentID which are maximum StudentID+1 b.
Create a database package specification and body called students which contains
a. getNextStudentId function which return the next available studentID which are maximum StudentID+1
b. validateStudentName function() which receive user input to return exists if the student exists before or not_exists if the student not inserted before (you can use cursor).
c. insrStudent procedure called by user to receive user input which are (name,GPA,phone) the procedure get the next student id using the getNextStudentId function then the procedure will insert new record to the table if the studentname doesnt exists before by using validateStudentName or display a message to enter another name if exists before.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
