How to generate CSV file using Oracle SQL Developer Command Line (SQLcl)

 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