Create a package named as INFO which contains procedure that is passed a student’s identification number and return student’s full name and phone number from the student table to the calling program and function, pass a department number to it. ...

Create a procedure in PLSQL to display the count of employees having department as “Marketing”. (Table needs to be created as per requirement of the question.) Note: Paste the code for table creation also along with the procedure code.

Create a package which includes a function to return a square of a number if it is positive else return an error message to the user.