SQL Functions are what I'm looking for.

 

Write function called GET_JOBTITLE where it accepts (receive) job_id as INPUT and return CHARACTER value ...

 

You will provide job as CHARACTER input and it will return also CHARACTER value.

 

Once the function receives the JOB_ID , it will go to HR_JOBS table and match that job_id and select job_title INTO local variable and that local variable will be return. 

2) Write a procedure called DEL_JOB to delete a job. Include the necessary exception handling code if no job is deleted