Sql*Plus User’s Guide and Reference

Restoring the System Variables
To restore the stored system variables, enter
START 
file_name
If the file has the default extension (as specified by the 
SET SUF[FIX] {SQL | text}
 on 
page 12-153 command), you do not need to add the period and extension to the file 
name.
You can also use the @ (at sign) or the @@ (double at sign) commands to run the script.
Example 2–1
Storing and Restoring SQL*Plus System Variables
To store the current values of the SQL*Plus system variables in a new script 
"plusenv.sql":
See Also:
■
SET
 command on page 12-88 for more information on these and 
other SET command variables you may wish to set in your 
SQL*Plus LOGIN file.
■
Using Predefined Variables
 on page 5-12 for more information 
about predefined variables. 

---

SQL*Plus Configuration
2-6
SQL*Plus User's Guide and Reference
STORE SET plusenv
Now the value of any system variable can be changed:
SHOW PAGESIZE
SET PAGESIZE 60
SHOW PAGESIZE
The original values of system variables can then be restored from the script:
START plusenv
SHOW PAGESIZE
Installing Command-line Help
Command-line help is usually installed during Oracle Database installation. If not, the 
database administrator can create the SQL*Plus command-line help tables and 
populate them with SQL*Plus help data by running a supplied SQL script from 
SQL*Plus.
The database administrator can also remove the SQL*Plus command-line help tables 
by running a SQL script from SQL*Plus.
Before you can install or remove SQL*Plus help, ensure that: 
■
SQL*Plus is installed. 
■
The ORACLE_HOME environment variable is set.
■
The SQL*Plus help script files exist: