Question: how to export data from oracle table to text file using sqlplus?
Answer: $ sqlplus.
$ sqlplus schema@//machine.domain:port/database.
set colsep , set headsep off set pagesize 0 set trimspool on.
set linesize # set numwidth #
spool file_path.
spool off.
SELECT title, primary_author FROM books;