Sql*Plus User’s Guide and Reference

–
HLPBLD.SQL - to drop and create new help tables. 
–
HELPDROP.SQL - to drop existing help tables. 
–
HELPUS.SQL - to populate the help tables with the help data. 
Running the hlpbld.sql Script to Install Command-line Help
Run the provided SQL script, HLPBLD.SQL, to load command-line help.
1.
Log in to SQL*Plus as the SYSTEM user with: 
SQLPLUS SYSTEM
You are prompted to enter the password you have defined for the SYSTEM user. 
2.
In UNIX run the SQL script, HLPBLD.SQL, from SQL*Plus with: 
@$ORACLE_HOME/SQLPLUS/ADMIN/HELP/HLPBLD.SQL HELPUS.SQL
In Windows run the SQL script, HLPBLD.SQL, from SQL*Plus with: 
Created file plusenv
PAGESIZE 24
PAGESIZE 60
PAGESIZE 24

---

SQL*Plus Configuration
Configuring SQL*Plus
2-7
@ORACLE_HOME\SQLPLUS\ADMIN\HELP\HLPBLD.SQL HELPUS.SQL
The HLPBLD.SQL script creates and loads the help tables.
Running the helpdrop.sql Script to Remove Command-line Help
Run the provided SQL script, HELPDROP.SQL, to remove the command-line help.
1.
Log in to SQL*Plus as the SYSTEM user with: 
SQLPLUS SYSTEM
You are prompted to enter the password you have defined for the SYSTEM user. 
2.
In UNIX run the SQL script, HELPDROP.SQL, from SQL*Plus with: 
@$ORACLE_HOME/SQLPLUS/ADMIN/HELP/HELPDROP.SQL
In Windows run the SQL script, HELPDROP.SQL, from SQL*Plus with: 
@ORACLE_HOME\SQLPLUS\ADMIN\HELP\HELPDROP.SQL
The HELPDROP.SQL script drops the help tables, and then disconnects. 
Configuring Oracle Net Services
If you plan to connect to a database other than the default, whether on the same 
computer or another computer, you need to ensure that Oracle Net is installed, and 
the database listener is configured and running. Oracle Net services are used by 
SQL*Plus. 
Oracle Net services and the database listener are installed by default during Oracle 
Database installation. For further information about installing and configuring Oracle 
Net, see the Oracle Database documentation at 
http://www.oracle.com/technology/documentation
.

---

SQL*Plus Configuration