Write a PL/SQL block to print information about a given employee. a.Declare a PL

Write a PL/SQL block to print information about a given employee. a.Declare a PL/SQL record based on the structure of the EMPLOYEES table. (2 pts)b.Use a SQL*Plus substitution variable p_empno to retrieve all information about a specific employee and store the information into the PL/SQL record. (6 pts)c.Use DBMS_OUTPUT.PUT_LINE to print selected information about the department. (2 pts)Output with employee_id = 150:SET SERVEROUTPUT ONDEFINE p_empno = 150(Execute these commands and then clear the screen. Next execute the program code)Employee Tucker is a SA_REP and was hired on 30-JAN-97.PL/SQL procedure successfully completed