Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gBD7ipa13034 for ; Fri, 13 Dec 2002 01:44:51 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gBD7ip313029 for ; Fri, 13 Dec 2002 01:44:51 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id UAA83789; Thu, 12 Dec 2002 20:27:26 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00519024; Thu, 12 Dec 2002 19:53:45 -0800 Message-ID: Date: Thu, 12 Dec 2002 19:53:45 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Tim Gorman" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Tim Gorman" Subject: Re: SQLPLUS spool file question Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00E8_01C2A1BF.7E41C460" ------=_NextPart_000_00E8_01C2A1BF.7E41C460 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable SQLPLUS spool file questionPerform a SHOW NEWPAGE command in SQL*Plus. = I imagine that you've got it set to "0"; if so, this is what is = producing the formfeed characters. Try setting either NEWPAGE NONE or = NEWPAGE ... ----- Original Message -----=20 From: Vergara, Michael (TEM)=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, December 11, 2002 9:58 AM Subject: RE: SQLPLUS spool file question Mark: Here is what I usually set in a SQL*Plus script where I will want to spool the output: set echo off pause off termout on feedback on set pagesize 55 linesize 95 tab off trimspool on I rarely use 'sqlplus -s', and I do not get the '^L' character in my spool files. I also have a shell script=20 that I use to trim off excess spaces and ^L characters from other folk's scripts. Here it is: #!/usr/bin/ksh # This is for HP-UX ksh. mv ${1} trim.temp if [ $? !=3D 0 ] ; then echo '' echo Error opening ${1} for move echo Aborting... echo '' exit fi # / /' | sed '1,$s/ *$//g' > ${1} rm trim.temp # #EOF# HTH, Mike -----Original Message----- From: Willett, Mark [mailto:mwillett@sunnen.com] Sent: Wednesday, December 11, 2002 8:04 AM To: Multiple recipients of list ORACLE-L Subject: SQLPLUS spool file question I'm creating a spool file of SQL commands based on several = "select...from" statements. When I "vi" my output file, I see a "^L" = character as the first character after each of my select statements. I = remember a solution being presented a few years ago that allowed you to = eliminate the "^L" on this list but I've managed to loose it. I seem to = remember that you must use silent mode (-s) and the proper setting of = several of the SQLPlus environment variables. Any help would be = appreciated Mark Willett Sunnen Products Company ------=_NextPart_000_00E8_01C2A1BF.7E41C460 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable SQLPLUS spool file question
Perform a SHOW NEWPAGE command in=20 SQL*Plus.  I imagine that you've got it set to "0";  if so, = this is=20 what is producing the formfeed characters.  Try setting either = NEWPAGE=20 NONE or NEWPAGE <non-zero-value>...
----- Original Message -----
From:=20 Vergara,=20 Michael (TEM)
Sent: Wednesday, December 11, = 2002 9:58=20 AM
Subject: RE: SQLPLUS spool file = question

Mark:
 
Here is what I usually set in a SQL*Plus script where I=20 will
want to spool the output:

   set echo off pause off termout on feedback=20 on
   set pagesize 55 linesize 95 tab off trimspool=20 on
 
I rarely use 'sqlplus -s', and I do not get the=20 '^L'
character in my spool files.  I also have a shell script =
that I use to trim off excess spaces and ^L=20 characters
from other folk's scripts.  Here it = is:
 
#!/usr/bin/ksh
# This is for HP-UX ksh.

mv ${1} trim.temp
if [ $? !=3D 0 ] ;  = then
  echo=20 ''
  echo Error opening ${1} for move
  echo=20 Aborting...
  echo ''
  exit
fi
#
/ /' | sed = '1,$s/=20 *$//g' > ${1}
rm trim.temp
 
#       = #EOF#
HTH,
Mike
 
 
 
-----Original Message-----
From: Willett, Mark=20 [mailto:mwillett@sunnen.com]
Sent: Wednesday, December 11, = 2002=20 8:04 AM
To: Multiple recipients of list=20 ORACLE-L
Subject: SQLPLUS spool file = question

I'm creating a spool file of SQL commands = based on=20 several "select...from" statements.  When I "vi" my output = file, I see=20 a "^L" character as the first character after each of my select=20 statements.  I remember a solution being presented a few years = ago that=20 allowed you to eliminate the "^L" on this list but I've managed to = loose=20 it.  I seem to remember that you must use silent mode (-s) and = the=20 proper setting of several of the SQLPlus environment = variables.  Any=20 help would be appreciated

Mark = Willett
Sunnen Products=20 Company

------=_NextPart_000_00E8_01C2A1BF.7E41C460-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: Tim@SageLogix.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).