Generate CSV output using sqlplus

19c (from 12.2) sqlplus we can simply use:

set markup csv on

Pre 19c we can also use:

set colsep ,
set headsep off
set pagesize 0
set trimspool on