Print a report of salaries for HR.EMPLOYEES.. Set echo on Set up a spool file to

Question

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:cs422awa2spool.txt Set appropriate column headings and formats Set appropriate linesize and pagesize. Give your report the title 'CS442a Seminar 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

Explanation / Answer

SPOOL OFF

Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14357/ch6.htm#i1082069

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

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