please use sql to answer the following question Create a procedure, ADD_EMPLOYEE., to insert a new employee into the EMPLOYEES table. The procedure should call a VALID_DEPTID function to check whether...


please use sql to answer the following question


Create a procedure, ADD_EMPLOYEE., to insert a new employee into the EMPLOYEES table. The procedure should call a VALID_DEPTID function to check whether the department ID specified for the new employee exists in the DEPARTMENTS table.


c. Call ADD_EMPLOYEE for the name Jane Harris in department 15. leaving other parameters with their default values. What is the result?



Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here