Question: Print a single formatted record 1- Set echo on 2- Set up a spool file to receive your output . I would suggest c:cs4210WA4spool.txt .

Print a single formatted record

1- Set echo on

2- Set up a spool file to receive your output . I would suggest c:\cs4210\WA4spool.txt .

3- SET SERVEROUTPUT ON

5- DECLARE a record variable (Emp_rec) using %ROWTYPE

6- In the BEGIN block use INTO to load a record into the declared variables for HR.EMPLOYEES for Employee_ID = 114

7- Use a CASE statement to print the associated Department Name for Department_ID

8- Add DBMS_OUTPUT lines to print each variable for the selected record

9- Use TO_CHAR to format Salary as 999,999.00

10- Add an EXCEPTION block to report when no data is found

11- Compile and run the procedure

12- Close the spool file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Print a single formatted record 1. Set echo on 2. Set up a spool file to receive your output for submission. I would suggest c:\cs4210\WA4spool.txt . 3. SET SERVEROUTPUT ON 4. DECLARE a record...

Q:

Print a report using SQL 1- Set echo on 2- Set up a spool file to receive your output for submission. I would suggest c:\cs4210\WA2spool.txt 3- Use the COLUMN statement to set the headings and...

Q:

In PL / SQL Print a PIVOT report of total employee salaries for HR . EMP _ DETAILS _ VIEW 1 . Set echo on 2 . Set up a spool file to receive your output 3 . SET SERVEROUTPUT ON 4 . Add a procedure...

Q:

1- Set echo on 2- Set up a spool file to receive your output for submission. I would suggest c:\cs4210\WA2spool.txt 3- Use the COLUMN statement to set the headings and formats for each column in...

Q:

Using Oracle 11g Sql Plus Working with Case Statement 1. Set echo on 2. SET SERVEROUT ON 3. Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa4spool.txt . 4....

Q:

Oracle Database 11g USING MY SQLPLUS CS4210 Written Assignment- Working with Case Statement 1. Set echo on 2. SET SERVEROUT ON 3. Set up a spool file to receive your output for submission. I would...

Q:

Using SQL/PLUS 1. Set echo on 2. SET SERVEROUT ON 3. Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa4spool.txt . 4. DECLARE a record variable (Emp_rec) using...

Q:

CS4210 Written Assignment- Working with Case Statement Points: 45 Assignment: Working with Case Statement Following the example in Lecture 4 1. Set echo on 2. SET SERVEROUT ON 3. Set up a spool file...

Q:

Using MySQL... 1. Set echo on 2. SET SERVEROUT ON 3. Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa4spool.txt . 4. DECLARE a record variable (Emp_rec) using...

Q:

CS4210 Written Assignment- Working with Case Statement Points: 45 Assignment: Working with Case Statement Following the example in Lecture 4 1. Set echo on 2. SET SERVEROUT ON 3. Set up a spool file...

Q:

Ronald Lau, chief engineer at South Dakota Electronics, has to decide whether to build a new state-of-the-art processing facility. If the new facility works, the company could realize a profit of...

Q:

A passenger on an interplanetary express bus traveling at v = 0.99c takes a 5-minute catnap, according to her watch. Show that her catnap from the vantage point of a fixed planet lasts 35 minutes.

Q:

When the entity's perpetual inventory master files are inadequate, the auditor will probably choose to test the physical inventory prior to the balance sheet date. Group of answer choices True False

Q:

Based on data below, compute the Current Ratio, Quick Ratio, and Debt Ratio. Data: Cash = $ 1 0 0 0 Inventory = $ 6 0 0 0 Accounts Receivable = $ 2 0 0 0 Accounts Payable = $ 4 0 0 0 Wages Payable =...

Q:

7. A group of managers (N25) participated in the problem-solving module of a leadership development program two weeks ago. The module consisted of two days in which the group focused on the correct...

Q:

9. What metrics might be useful for evaluating the effectiveness of a companys training function? Discuss and rate their importance.

Q:

10. What acceptable methods can be used to show the costs and benefits of training without collecting statistics and conducting analyses? Explain these methods and their strengths and weaknesses...