Oracle SQL - Store Setting to a file


To save all your current SQL*Plus settings in a SQL*Plus script file, use the STORE SET command.

The syntax of this command.

SQL> STORE SET <filename>[.sql] [REPLACE|APPEND]

The brackets [] means optional command clauses.

If you saved SQL*Plus settings in a script file by using the STORE SET command, you can restore those settings using the START (or @) command.

Related Topic