Simple example
SQL> store set c:\users\rene\sqlplus-attributes
Created file c:\users\rene\sqlplus-attributes
Note: SQL*Plus does not show the extension, the file is created with the extension .sql.
Content of the creted file
The file that is created with the
store command contains a list of
set commands:
set appinfo OFF
set appinfo "SQL*Plus"
set arraysize 15
set autocommit OFF
set autoprint OFF
set autorecovery OFF
…
set verify OFF
set wrap ON
set xmloptimizationcheck OFF
Reverting to saved values
After modifying some set values, it's possible to revert to the saved values:
SQL> @ c:\users\rene\sqlplus-attributes