Skip to content

Set options for SQLPlus

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

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*