SQL*Plus Getting Started Release 9.0.1 for Windows Part Number A88829-01 |
|
This chapter provides information to help you install SQL*Plus components.
Specific topics discussed are:
The CD-ROM insert that accompanies your product CD-ROM includes the following information about SQL*Plus:
Online help is available from the command line of either the graphical user interface or the command line interface while you are using SQL*Plus. The database administrator creates the SQL*Plus help tables and populates them with SQL*Plus help data.
Before you can install SQL*Plus help, ensure that:
%ORACLE_HOME%\SQLPLUS\ADMIN\HELP\
The help script files are:
%ORACLE_HOME%\BIN\
SQL*Plus help is installed automatically during Oracle9i installation. There are also two ways to manually install SQL*Plus help:
SET SYSTEM_PASS=SYSTEM/PASSWORD
where PASSWORD is the password you have defined for the SYSTEM user. The default SYSTEM user password is MANAGER.
The HELPINS utility reads this login from SYSTEM_PASS to run successfully.
C:\> %ORACLE_HOME%\BIN\HELPINS US
C:\> SQLPLUS SYSTEM/PASSWORD
where PASSWORD is the password you have defined for the SYSTEM user.
SQL> @%ORACLE_HOME%\SQLPLUS\ADMIN\HELP\HELPBLD.SQL HELPPATH HELPUS.SQL
where HELPPATH is the path to the SQL*Plus help directory containing the file HELPUS.SQL. HELPPATH is usually:
%ORACLE_HOME%\SQLPLUS\ADMIN\HELP
To access SQL*Plus help, enter the following command in SQL*Plus:
SQL> HELP
If you know the topic for which you want help, enter the following command:
SQL> HELP topic
where topic is a SQL*Plus help topic.
To display a list of available help topics, enter one of the following commands:
SQL> HELP INDEX
or
SQL> HELP TOPICS
To get help for the COLUMN command, enter
SQL> HELP COLUMN
If you get a response that help is unavailable, check that you have correctly installed SQL*Plus help in the SYSTEM schema.
For more information about the HELP command, see Chapter 8, "Command Reference" in the SQL*Plus User's Guide and Reference.
Included with Oracle9i, are a number of sample schemas. The SQL*Plus tutorial and examples use the EMP_DETAILS_VIEW view of the Human Resources (HR) sample schema. This schema contains personnel records for a fictitious company. For information about unlocking and accessing the HR sample schema, see Chapter 1 of the SQL*Plus User's Guide and Reference. For further information about the sample schemas included with Oracle9i, see the Oracle9i Sample Schemas guide.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|