$(15$ Marks$)$

Create a host variable named g$\_$ename and populate it with any employee name from

the EMP table. Then, write an anonymous block that displays the employee number, name

and job. Use local variables as required also making use of the $\%$TYPE attribute whenever

possible in variable declaration. Finally, display the job status using the following rules:

Job is CLERK, status should be set to C

Job is ANALYST, status should be set to A

Job is MANAGER, status should be set to M

Any other job, status should be set to $O$