SQL Plus. Getting Started

SQL*Plus User’s Guide and Reference is intended for business and technical users and system administrators who want to use SQL*Plus in the Windows 2000, Windows NT or Windows 95/98 operating environments.This guide assumes that you are familiar with: * SQL*Plus commands and general features. You should refer to the generic SQL*Plus documentation set before using this guide. See “Related Documentation” later in this chapter. * Commands for deleting and copying files and the concepts of the search path, subdirectories, and path names. * Fundamentals of the Microsoft Windows 2000, Windows NT or Windows 95/98 operating systems.To use this guide, you need a basic understanding of the SQL database language. If you do not have any familiarity with this database tool, you should refer to the Oracle9i SQL Reference. If you plan to use the PL/SQL database language in conjunction with SQL*Plus, refer to the PL/SQL User’s Guide and Reference for information on using PL/SQL.

---

Table of contents :
Contents……Page 3
Send Us Your Comments……Page 5
Preface……Page 7
1 Introducing SQL*Plus……Page 17
Basic Concepts……Page 18
Obtaining Online Help……Page 19
2 Installing SQL*Plus Help and Demonstration Tables……Page 21
Prerequisites……Page 22
Accessing SQL*Plus Help……Page 23
Accessing Sample Tables……Page 24
3 Using SQL*Plus……Page 25
Interpreting Arguments in Windows……Page 26
Using a Special Character……Page 27
Starting the GUI from the Windows Menu……Page 28
Starting the GUI from the Windows Command Prompt……Page 29
Using the Command Keys……Page 30
File Menu……Page 31
Edit Menu……Page 32
Options Menu……Page 33
Setting Options and Values Using the Environment Dialog……Page 34
Changing the GUI Font and Font Size……Page 36
To Change the Windows GUI Font and Font Size……Page 37
Exiting SQL*Plus……Page 38
4 Operating System-Specific References……Page 39
Interpreting Error Messages……Page 40
@, @@, and START Commands……Page 41
PRODUCT_USER_PROFILE Table……Page 42
A Customizing Operating System Parameters……Page 45
SQLPATH Parameter Description……Page 46
SQLPLUS Environment Variable……Page 47
Index……Page 49