Use Sqlplus to output only data to a text file instance

The data is stored as a file (such as: create_csv.sql) and then executed in Sqlplus to output the data to the specified file.
--Number of characters per line, max value is 999
Set Linesize 800
--This parameter sets the number of rows per page output, including Ttitle (header), btitle (bottom caption), column (column headings), and blank lines. N=0 indicates no new page is generated
Set pagesize 0
--Column Settings
--col username format A4
--col a format 999,999,999
--The headings for each column, including text and underscores, are displayed on the results report. Prohibit output column headers
Set Heading off
--At the end of the query, give the number of records of the query results. Suppress the last line of count feedback
Set Feedback off
--whether the command itself is displayed on the screen when the command file is executed
Set echo off
--
Set Termout off
--empty extra space, such as: Linesize too long
Set Trimout on
Set Trimspool on
--Production Data command
Spool E:\output cott_spool_emp.csv;
Select Empno| | ', ' | | ename| | ', ' | | job| | ', ' | | mgr| | ', ' | | hiredate| | ', ' | | SAL from EMP;
Spool off;