This would be from using oracle database Print a report of salaries for HR.EMPLO

Question

This would be from using oracle database

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:CS4210wa2spool.txt

Set appropriate column headings and formats

Set appropriate linesize and pagesize. Give your report the title 'CS442a Module 2 Written Assignment'

Set a break on DEPARTMENT_ID and REPORT

Compute subtotals on DEPARTMENT_ID and a grand total on REPORT

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

Close the spool file

Thank you

Explanation / Answer

Set linesize 1000

Set pagesize 1000

Spool c:CS4210wa2spool.txt

Title center  'CS442a Module 2 Written Assignment'

Break on DEPARTMENT_ID ;

SELECT DEPARTMENT_ID, EMPLOYEE_ID, FIRST_NAME, LAST_NAME, and SALARY from HR. EMPLOYEES WHERE DEPARTMENT_ID <50 ORDER BY DEPARTMENT_ID ;

SPOOL OFF;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.