SQL*Plus
Getting Started Release 8.1.6 for Windows A77480-01 |
|
SQL*Plus Getting Started for Windows provides information about the SQL*Plus product that is specific to the Microsoft Windows NT 4.0, Windows 95, and Windows 98 operating system environments.
Specific topics discussed in this preface are:
This guide assumes that you are familiar with the following:
This guide is for all users who want to use SQL*Plus in the Windows NT or Windows 95/98 operating environments.
This guide is organized as follows:
Chapter 1, "Introducing SQL*Plus"Chapter 2, "Installing SQL*Plus Help and Demonstration Tables"
Chapter 3, "Using SQL*Plus"Explains how to start and use SQL*Plus from the command line interface and the graphical user interface, and describes the menu options.
Provides command information specific to the Windows NT/95/98 environments which are cross-referenced in SQL*Plus User's Guide and Reference.
Describes how to customize your SQL*Plus configuration by changing the SQLPATH parameter in the Windows NT/95/98 registry
SQL*Plus Getting Started for Windows provides information specific to SQL*Plus on Windows-based platforms only. For information about SQL*Plus cross-platform support, features, and commands, refer to the generic SQL*Plus documentation set on the product CD-ROM. In addition to the complete documentation for the Oracle Enterprise Edition for Windows product, the following SQL*Plus documentation is available for online viewing:
Online help for using SQL*Plus is available from the SQL*Plus command line during a session. The SQL*Plus help tables must be created and populated by the database administrator first. See "Installing SQL*Plus Online Help" in Chapter 1 for information about installing SQL*Plus online help.
The following conventions are used in this guide.
Convention | Example | Meaning |
---|---|---|
All uppercase plain |
ALTER DATABASE |
Indicates command names, SQL reserved words, and keywords. All uppercase plain is also used for directory names and file names. |
Italic |
filename This section describes new SQL*Plus features specific to Windows NT/95/98. |
Indicates a value that you must provide. For example, if a command asks you to type filename, you must type the actual name of the file. Italic is also used for emphasis in the text and to indicate the titles of other guides. |
Oracle database |
|
The database component of Oracle8i. |
C:\> |
C:\>ORACLE\ORA81 |
Represents the Windows command prompt of the current hard disk drive. Your prompt can differ and can, at times, reflect the subdirectory in which you are working. Referred to as the MS-DOS command prompt in this guide. |
Backslash (\) before a directory name |
\ORADATA |
Indicates that the directory is a subdirectory of the root directory. |
ORACLE_HOME and ORACLE_BASE |
Go to the ORACLE_BASE\ORACLE_HOME\ADMIN directory |
In previous releases when you installed SQL*Plus, all subdirectories were located under a top level ORACLE_HOME directory, that by default was: or whatever you may have called your Oracle home. With this Optimal Flexible Architecture (OFA)-compliant release, all subdirectories are no longer under a top level ORACLE_HOME directory. There is now a new top level directory called ORACLE_BASE, which by default is C:\ORACLE. For more information about multiple Oracle homes and Optimal Flexible Architecture (OFA), see Oracle8i Administrator's Guide for Windows NT. |
HOME_NAME |
OracleHOME_NAMETNSListener |
Represents the Oracle home name. The home name can be up to sixteen alphanumeric characters. The only special character allowed in a home name is the underscore. |
Symbols |
parentheses ( ) |
Symbols other than brackets and vertical bars must be entered in commands exactly as shown. |
|
![]() Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|