Question
Following the example in Lecture 3, write a program to print a record from HR.EMPLOYEES. Set echo on SET SERVEROUT ON Set up a spool
Following the example in Lecture 3, write a program to print a record from HR.EMPLOYEES.
Set echo on
SET SERVEROUT ON
Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa3spool.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 into the declared variables from HR.EMPLOYEES for an Employee_ID to be determined at run time
Add DBMS_OUTPUT lines to print each variable for the select record
Add a EXCEPTION block to report when no data is found
Compile and run the procedure for the Employee, 114
Close the spool file
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started