|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:
The help script files are:
SQL*Plus help is installed automatically during Oracle9i installation. There are also two ways to manually install SQL*Plus help:
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.
where PASSWORD is the password you have defined for the SYSTEM user.
where HELPPATH is the path to the SQL*Plus help directory containing the file HELPUS.SQL. HELPPATH is usually:
To access SQL*Plus help, enter the following command in SQL*Plus:
If you know the topic for which you want help, enter the following command:
where topic is a SQL*Plus help topic.
To display a list of available help topics, enter one of the following commands:
To get help for the COLUMN command, enter
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.
Dates in the sample schemas use four digit years. As the default date format in SQL*Plus is DD-MM-YY, dates displayed show only a two digit year. To control the way dates are displayed, either use ALTER SESSION SET NLS_DATE_FORMAT ='DD-MM-YYYY', or use the SQL TO_CHAR function in your SELECT statements .