A procedure update_department. This procedure will take the department ID and new Department name. Use dynamic SQL
Fantastic news! We've Found the answer you've been seeking!
Question:
- A procedure update_department. This procedure will take the department ID and new Department name.
- Use dynamic SQL to update the name of the department with the new department name passed in the store procedure. The update should be performed based on the department id.( You can use any Dynamic SQL method)
- Show the execution of the procedure.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: