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