please use store procedures to answer the following question Create a procedure to update Job Title for a given JOB_ID This procedure is called Update_Job_Title will have two INPUT parameters....

please use store procedures to answer the following question

1. Create a procedure to update Job Title for a given JOB_ID

This procedure is calledUpdate_Job_Title will have two INPUT parameters.

p_job_id as VARCHAR2    as INPUT parameter and alsop_new_job_title  as VARCHAR2 as INPUT parameter.

In BEGIN and END executable section

            Execute UPDATE command on JOBS table to change title of a JOB_ID

         Here is the command that you can use in BEGIN and END

                      UPDATE JOBS  SET job_title=p_new_job_title WHERE job_id= p_job_id;

Test your code by executing procedure for below job_id.

Currently in Jobs table you have Job_id = ‘MK_MAN’ and job_title=’ Marketing Manager’

Change  title from  Marketing Manager    to    Marketing Sr. Manager

executeUpdate_Job_Title(‘MK_MAN’, ‘Marketing Sr. Manager’ )