Sqlplus Set Commands

/* multiple line comments can go between these delimiters */ set term off -- term = on will display on terminal screen (off = show in log only) set echo on -- echo = on will display the command on screen (+ spool) -- echo = off will display the command on screen but not in spool files. -- interactive commands are always echoed to screen/spool. set trimout on -- trimout = on will remove trailing spaces from output set trimspool on -- trimspool = on will remove trailing spaces from spooled output set heading off -- heading = off will hide column headings set feedback off -- feedback = on will count rows returned set pause off -- pause = on .. press return at end of each page set pagesize 0 -- pagesize = height 54 is 11 inches (0 will supress all headings and page brks) set linesize 80 -- linesize = width of page (80 is typical) set verify off -- verify = on will show before and after substitution variables -- start spooling to a log file spool c:\temp\my_log_file.log --- the rest of the sql commands go here -select * from global_name; spool off