Name
STORE
Synopsis
STORE SET filename
[CRE[ATE] | REP[LACE] | APP[END]]
STORE generates a file of SET commands based on the current state of those settings. For example:
STORE SET current_settings REPLACE ... @current_settings
In this example, the first command stores the current settings while the second command restores those settings by executing the file generated by the STORE command.
Parameters
- filename
Is the name of the file to which you want to write the SET commands.
- CRE[ATE]
Causes the command to fail if the file already exists. This is the default.
- REP[LACE]
Causes SQL*Plus to overwrite any existing file with the same name.
- APP[END]
Appends the SET commands to an existing file.
Get Oracle SQL*Plus Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.