-- Define report title TTITLE CENTER '========================================' SKIP 1 - CENTER 'EMPLOYEE SALARY REPORT' SKIP 1 - CENTER '========================================' SKIP 2
-- Spool output to file SPOOL sales_report_2024.txt -- Your query here SPOOL OFF -- Set environment SET ECHO OFF SET FEEDBACK ON SET LINESIZE 200 SET PAGESIZE 60 SET VERIFY OFF -- Clear any previous settings CLEAR COLUMNS CLEAR BREAKS CLEAR COMPUTES oracle sql download
-- Column formatting COLUMN employee_id FORMAT 9999 HEADING 'Emp ID' COLUMN employee_name FORMAT A25 HEADING 'Employee Name' COLUMN department FORMAT A20 HEADING 'Department' COLUMN salary FORMAT $99,999.00 HEADING 'Salary' COLUMN hire_date FORMAT A10 HEADING 'Hire Date' oracle sql download