SQL Functions are what I'm looking for. Write function called GET_JOBTITLE where it accepts (receive) job_id
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Related Book For
Foundations of Financial Management
ISBN: 978-1259024979
10th Canadian edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta
Posted Date: