| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus Saving Environment?
Give this a try: This was cut out of the SQLPLUS HTML manual, (sorry about the
ugliness)
STORE Purpose
Saves attributes of the current SQL*Plus environment in a host operating system file (a command file).
Syntax
STORE {SET} file_name[.ext] [CRE[ATE]|REP[LACE]| APP[END]]
Terms and Clauses
Refer to the following list for a description of each term or clause:
SET Saves the values of the system variables.
Refer to the SAVE command for information on the other terms and clauses in the STORE command syntax.
Usage Notes
This command creates a command file which can be executed with the START, @ or @@ commands.
If you want to store a file under a name identical to a STORE command clause (that is, CREATE, REPLACE or APPEND), you must put the name in single quotes or specify a file extension.
Example
To store the current SQL*Plus system variables in a file named DEFAULTENV with the default command-file extension, enter
SQL> STORE SET DEFAULTENV To append the current SQL*Plus system variables to an existing file called DEFAULTENV with the extension OLD, enter
SQL> STORE SET DEFAULTENV.OLD APPEND Georg Schulte Althoff wrote:
> I'm using SQL*Plus (Version 3.3.4.0.0) and I hate it to reconfigure the
> environment every time I start a new instance of the program.
> If I close the program, current values for "linesize" and "pagesize"
> are not saved. I have to set them via Optionen/Umgebung (Options/Environment
> ?)
> by selecting them from "Optionen mit SET" (Options with Set ?).
>
> Is there anyone who knows how to save these two values
>
> Thank you very much
>
> Georg
--
55 Broadway - 21st Floor
New York, New York 10006
Phone: 800.221.5327 x2136
Fax: 212-825-2245
E-Mail: MWeinstock_at_lds.com
Web: http://www.lds.com
Received on Wed Jan 12 2000 - 10:29:07 CST
 |
 |