Re: variable in sqlplus

"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