Tech and travel

Set options for SQLPlus

2007-05-17

The following options are useful in SQLplus when spooling to a file. They make sure there are no headers or other stuff in the output that does not execute in SQLPlus.

-- Do not print the number of records selected, updated, ..
set feedback off
-- Do not print column headings
set heading off
-- Do not print old and new when substituting
set show off
-- Removes blanks at the end of spooled lines
set trimspool on
-- surpress output of scripts run with @, @@ or start
set termout off
-- Setting pagesize to 0 suppresses all headings, page breaks,
-- titles, the initial blank line, and other formatting information.
set pagesize 0
-- surpress output of scripts run with @, @@ or start
set echo off
-- removes blanks at the end of each line (not from spooled output though
set trimout on

Copyright (c) 2024 Michel Hollands