Go to main content
STORE SET file_name[.ext] [ CRE[ATE | REP[LACE] | APP[END]]
Saves attributes of the current SQL*Plus environment in a script.
See SAVE for information on the other terms and clauses in the STORE command syntax.
Saves the values of the system variables.
This command creates a script which can be executed with the START, @ (at sign) or @@ (double at sign) 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.
To store the current SQL*Plus system variables in a file named DEFAULTENV with the default command-file extension, enter
STORE SET DEFAULTENV
To append the current SQL*Plus system variables to an existing file called DEFAULTENV with the extension OLD, enter
STORE SET DEFAULTENV.OLD APPEND