This blog is explaining how to generate controlled CSV file using Oracle SQL Developer Command Line (SQLcl).
Oracle SQL Developer Command Line (SQLcl) is a free command
line interface for Oracle Database. It allows you to interactively or batch
execute SQL and PL/SQL. SQLcl provides in-line editing, statement completion,
and command recall for a feature-rich experience, all while also supporting
your previously written SQL*Plus scripts.
Download Link:
https://www.oracle.com/database/sqldeveloper/technologies/sqlcl/
Note: Below image is modified. Original image is taken from website:
https://exasol.my.site.com/s/article/Proper-csv-export-from-Oracle?language=en_US
For exploraing features of SQLcl, below see:
https://docs.oracle.com/en/database/oracle/sql-developer-command-line/22.4/index.html