Question: Question 3 : ( use schemas des 0 3 , and script 7 northwoods ) Create a function called find _ age that accepts a

Question 3: (use schemas des03, and script 7northwoods)
Create a function called find_age that accepts a date and return a number.
The function will use the sysdate and the date inserted to calculate the age of the person with the
birthdate inserted.
Create a procedure that accepts a student number to display his name, his birthdate, and his age using
the function find_age created above.
Handle the error ( use EXCEPTION)

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 Programming Questions!