Question: 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:cs4210WA2spool.txt

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 formats for each column in HR.EMPLOYEES

4- Set appropriate linesize and pagesize. Give your report the title 'CS4210 Seminar 2 Written Assignment'

5- Set a break on DEPARTMENT_ID and REPORT

6- Compute subtotals on DEPARTMENT_ID and a grand total on REPORT

7- Show just the fields DEPARTMENT_ID, EMPLOYEE_ID, FIRST_NAME, LAST_NAME, and SALARY from HR.EMPLOYEES for Department_ID < 50 . (Don't forget to order by DEPARTMENT_ID.)

8- 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!

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...

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)...

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...

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...

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...

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...

My assignment is to do but he want use to the if statement to do You can use it to determine the Department they work for, like we did in the past with a CASE. You can use it to print a message if...

Following the example in Lecture 2, Print a report of salaries for HR.EMPLOYEES.. Set echo on Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa2spool.txt Set...

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....

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...

2. Consider the free energy functional of an inhomogeneous system that depends on a non-conserved order parameter 7 and temperature T, written in one-dimension as: T [G- G = Go+ a(T-Tc)n + Cn + Bn...

The system of four tanks shown in Figure 1 is part of an industrial process. Tanks A, B, C, and D have fluid heights of x, y, h, and z (in meters) respectively. Fluid flows into tank A at rate of...

urrent Attempt in Progress Pharoah Co . reported $ 1 4 2 , 0 0 0 of net income for 2 0 2 5 . The accountant, in preparing the statement of cash flows, noted the following items occurring during 2 0 2...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

3. Describe the role of metaphor in understanding intercultural communication.

3. Communication of White Identity. Go to the website http://stuffwhitepeoplelike .com/. This website parodies the stereotypes of white people, and by extension, the stereotyping of other groups....

b. What groups were most represented? Why do you think this is so?