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

Home -> Community -> Usenet -> c.d.o.server -> Re: variable in sqlplus

Re: variable in sqlplus

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 5 Oct 2004 11:32:22 -0400
Message-ID: <7rWdnU6Y6uUXI__cRVn-pw@comcast.com>

"Johannes" <johannes_at_merckle.de> wrote in message news:2sfspgF1kuabiU1_at_uni-berlin.de...
| Hello to all,
|
| I want to start a sqlplus-script for multiple db instances at one time
| generating a logfile.
| Specified within the sqlplus-script something like this "DEFINE
| spoollog=C:\_<Instance_name><SID>"
| whereas <Instance_name> and <SID> should be filled up with the appropriate
| values.
| But I don't know how to transmit this one.
| Thank you for all your help.
|
| Best Regards
| Johannes
|
|

you probably need to look into the NEW_VALUE option in the SQL*PLus manual (should be chapter 4, Formatting Query Results)

++ mcs Received on Tue Oct 05 2004 - 10:32:22 CDT

Original text of this message

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