Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Willett, Mark
INET: mwillett_at_sunnen.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_at_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). Received on Wed Dec 11 2002 - 10:04:05 CST
![]() |
![]() |