SET COLSEP ',' SET PAGESIZE 0 SET FEEDBACK OFF SET HEADING OFF SPOOL report.csv SELECT / csv / * FROM your_table; SPOOL OFF
-- Define report title TTITLE CENTER '========================================' SKIP 1 - CENTER 'EMPLOYEE SALARY REPORT' SKIP 1 - CENTER '========================================' SKIP 2 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' SET COLSEP ',' SET PAGESIZE 0 SET FEEDBACK