SQL * PLus help manual for SP2-0171)

For masters who often work under SQL * Plus, they always query the help commands of SQL * Plus from time to time. Too many.

For masters who often work under SQL * Plus, they always query the help commands of SQL * Plus from time to time. Too many.

For masters who often work under SQL * Plus, they always query the help commands of SQL * Plus from time to time. It's too much to remember. The help Command is provided in SQL * Plus to help describe the usage of all commands. Hey, you no longer need to check SQL * Plus reference. By default, the help manual for SQL * Plus is not installed for Oracle 10 Gb. You need to install it manually. The same installation method is used in Oracle 10/11g. The following describes how to install and use help.

1. Install sqlplus help

System @ CNMMBO> help
SP2-0171: HELP system not available.

Robin @ SZDB: ~> Cd $ ORACLE_HOME/sqlplus/admin/help -- the script path is in the ORACLE_HOME, sqlplus/admin/hlep directory.
Robin @ SZDB:/users/oracle/OraHome10g/sqlplus/admin/help> ls
Helpbld. SQL helpdrop. SQL helpus. SQL hlpbld. SQL

Robin @ SZDB:/users/oracle/OraHome10g/sqlplus/admin/help> head-40 hlpbld. SQL
--
-- Copyright (c) Oracle Corporation 1983,200 3. All Rights Reserved.
--
-- NAME
-- Hlpbld. SQL
--
-- DESCRIPTION
-- Builds the SQL * Plus HELP table and loads the HELP data from
-- Data file. The data file must exist before this script is run.
--
-- USAGE
-- To run this script, connect as SYSTEM and pass the datafile to be
-- Loaded as a parameter e.g.
--
-- Sqlplus system/ @ Hlpbld. SQL helpus. SQL
--
--

Define datafile = & 1

--
-- Create the HELP table
--

Drop table help;
CREATE TABLE HELP
(
TOPIC VARCHAR2 (50) not null,
Seq number not null,
INFO VARCHAR2 (80)
) PCTFREE 0 STORAGE (INITIAL 48 k pctincrease 0 );

Grant select on help to public;

--
-- Insert the data into HELP.
--

@ & DATAFILE

System @ CNMMBO> @ $ ORACLE_HOME/sqlplus/admin/help/hlpbld. SQL helpus. SQL
DROP TABLE HELP
*
ERROR at line 1:
ORA-00942: table or view does not exist

Table created.

Grant succeeded.
...

Commit complete.

View dropped.