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;