shell spool

If you wish to use SQL*Plus Command-line , you'll simply issue the sqlplus command from your shell:

1. $ sqlplus.
2. $ sqlplusschema@//machine.domain:port/database.
3. set colsep , set headsep off set pagesize 0 set trimspool on.
4. set linesize # set numwidth #
5. spool file_path.
6. spool off.
7. SELECT title, primary_author FROM books;