Oracle SQL

Objective: Associates would need to develop stored procedures (or) functions for the below-mentioned problem statements.

NOTE: Students should create all the stored procedures and functions inside package mentioned in the problem statement. Also, all the procedure names should be appended with the employee id.

Create a package with name UMS_Package_.

Create a stored procedure Update_Student_Contact_Info _ in the package which takes registration number, new email, and contact # as inputs and updates that students contact number, email id.

Create a stored procedure which accepts a character input and displays the name and the phone numbers of students which starts with the given character input.

Create a function which accepts the student registration id, returns the age of a student in number based on the DOB and the current date.

Create a function which accepts the student registration id and returns the numbers of years has passed since the student joined the college. Hint: Use the data of joining of the student.