(Solved) : Following Example Lecture 3 Write Program Print Record Hremployees Set Echo Set Serverout Q26276269 . . . .

Following the example in Lecture 3, write a program to print arecord from HR.EMPLOYEES.

Set echo on

SET SERVEROUT ON

Set up a spool file to receive your output for submission. Iwould suggest c:CS4210wa3spool.txt .

DECLARE variables for Department_ID, Employee_ID, First_Name,Last_Name, and Salary

In the BEGIN block add a select statement to read a record intothe declared variables from HR.EMPLOYEES for an Employee_ID to bedetermined at run time

Add DBMS_OUTPUT lines to print each variable for the selectrecord

Add a EXCEPTION block to report when no data is found

Compile and run the procedure for the Employee, 114

Close the spool file

Expert Answer

An answer will be