|SQL*Plus Getting Started
Release 9.2 for Windows
Part Number A92157-01
This chapter provides information to help you install SQL*Plus components in Windows environments.
Specific topics discussed are:
The CD-ROM insert that accompanies your product CD-ROM includes the following information about SQL*Plus:
Command-line help is available from the graphical user interface, the command-line user interface and the iSQL*Plus user interface while you are using SQL*Plus. The database administrator creates the SQL*Plus help tables and populates them with SQL*Plus help data.
There is also iSQL*Plus online help available only from the iSQL*Plus user interface, see the SQL*Plus User's Guide and Reference.
Before you can install SQL*Plus command-line help, ensure that:
The help script files are:
SQL*Plus command-line help is installed automatically during Oracle9i installation. There are also two ways to manually install SQL*Plus command-line 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 command-line 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 command-line help in the SYSTEM schema.
For more information about the HELP command, see the Help command in the SQL*Plus User's Guide and Reference.
Included with Oracle9i, are a number of sample schemas. The SQL*Plus 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 .