Search notes:

SQLPATH - spooling helpers

spool.sql sets some SQL*Plus settings in a way, that the spool command writes clean files. These files are used, for example, in insert_statement_creator.sql.

spool.sql

Start spooling in a clean way:

--  Change settings so that output printed to
--  SQL*Plus (via dbms_output.put_line) can
--  be spooled into a file without headers
--  or other distracting features.
--
--  developed to be used along with dot.sql
--
set feedback off
set echo off
set trimspool on
set termout off
set lines 500
set pages 0
spool &1

Github repository Oracle-SQLPATH, path: /spool.sql

spool_off.sql

End spooling

--
--    closes the spooling initiated by ./spool.sql
--
spool off
set lines            190
set pages           5000
set termout           on

Github repository Oracle-SQLPATH, path: /spool_off.sql

SQLPATH - spooling helpers

spool.sql

spool_off.sql

See also