Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Parameter to teh spool command

Re: Parameter to teh spool command

From: Sajid Iqbal <sajid_at_u-net.net>
Date: Tue, 30 May 2000 17:03:53 +0100 (BST)
Message-Id: <10513.107119@fatcity.com>


try spool &name.log

--
U-NET Ltd  a VIA NET.WORKS Inc company
Sajid Iqbal                    | Mail : sajid_at_u-net.net
Database DBA/Developer         | Ext  : 4485
U-NET Ltd                      | ICQ  : 43903417
Warrington, Cheshire, UK       |  


On Tue, 30 May 2000, Witold Iwaniec wrote:


> Hi all
>
> I guess it is very simple but I must be missing something...
>
> I would like to use a parameter for the spool filename so that I can
> run my script number of times and keep all spool files.
> But using:
>
> spool $1.log
> (or spool %1.log in Windows)
> does not do it.
>
> Can I do it in the sql script or do I have to go for other tools to
> generate the file name and open it?
>
> Regards
>
> Witold
> ======================================
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> wiwaniec_at_novalistech.com
> http://www.novalistech.com
> --
> Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Tue May 30 2000 - 11:03:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US