STORE
STORE is a relatively new addition to the SQL*Plus command set. It generates a file of SET commands based on the current state of those settings. This file can be used after those settings have been changed to reset everything back to a known state.
STORE SET filename
[CRE[ATE]|REP[LACE]|APP[END]]
where:
- STORE
Is the command.
- SET
Is an option indicating what you want to store. Currently, the only option available is SET.
- filename
Is the name of the file, including the path and extension, to which you want to write the SET commands.
- CRE[ATE]
Causes the command to fail if the file already exists.
- REP[LACE]
Causes SQL*Plus to overwrite any existing file with the same name.
- APP[END]
Causes the SET commands to be appended to an existing file.
Get Oracle SQL*Plus: The Definitive Guide 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.