Index

A  B  C  D  E  F  G  H  I  L  M  O  P  Q  R  S  T  V  W 

$ command, 4-4

@ command, 4-3

@@ command, 4-3

---

A

accessing sample tables, 2-4

AFIEDT.BUF, 3-7

ANSI escape sequences, warning about, 4-3

audience, SQL*Plus, viii

---

B

basic concepts, 1-3

block, defined, 1-3

buffer

clearing your screen, 3-7

screen, 1-3

screen area, 3-8

SQL, 1-3, 3-6

---

C

cancelling an in-progress operation, 3-6

CD-ROM contents, ix, 2-2

clearing your screen, 3-7

code conventions, used in this guide, x

command files

opening, 3-5

saving, 3-6

command keys, SQL*Plus GUI, 3-5

command line interface, 3-2

command, defined, 1-3

connect string, 3-3

copying text, 3-4, 3-7

---

D

DEMOBLD.SQL file, 2-4

DEMODROP.SQL file, 2-4

demonstration tables, 2-4

documentation

conventions used in this guide, x

---

E

Edit menu, 3-7

editor

defining, 3-7

invoking, 3-7

environment

setting up SQL*Plus, 3-8, 4-3

Environment command, 3-8

Environment Variable

SQLPLUS, A-3

error messages, interpreting, 4-2

exiting SQL*Plus, 3-10

exiting SQL*Plus GUI, 3-6

---

F

File menu, 3-5

finding text, 3-7

---

G

GLOGIN.SQL file, 4-3

graphical user interface

menus, 3-5

starting, 3-3

---

H

help

accessing online help, 2-3

installation prerequisites, 2-2

installing, 2-2

Help menu, 3-9

HOME_NAME, defined, xi

HOST command, 4-4

host string, 3-3

---

I

installing

SQL*Plus online help, 2-2

---

L

LOCAL parameter, 4-5

Log On dialog, 3-3

LOGIN.NEW file, warning about, 4-3

LOGIN.SQL file, 4-3

---

M

menus

graphical user interface, 3-5

mouse, using to copy commands, 3-4

MS-DOS, accessing from SQL*Plus, 4-4

multiple Oracle homes

defined, xi

---

O

online help

accessing online help, 2-3

installation prerequisites, 2-2

installing, 2-2

obtaining for SQL*Plus, ix, 2-2

operating systems, supported by SQL*Plus, vii

Optimal Flexible Architecture (OFA), xi

Options menu, 3-8

ORA error messages, 4-2

ORACLE_BASE, defined, xi

ORACLE_HOME, defined, xi

overview, 1-2

---

P

parameter

SQLPATH, 4-3, A-2

pasting text, 3-7

PL/SQL, relation to SQL*Plus, 1-2

Prerequisites

installing online help, 2-2

prerequisites, viii

PRODUCT_USER_PROFILE table, 4-4

PUPBLD.SQL file, 4-4

---

Q

query results, defined, 1-3

query, defined, 1-3

---

R

REGEDIT.EXE, A-2

REGEDT32.EXE, A-2

registry, using, A-2

report, defined, 1-3

rules, for Windows arguments, 3-2

Run menu command

lists and executes SQL and PL/SQL, 3-6

---

S

sample tables, 2-4

saving, command files, 3-6

screen buffer area, 3-8

Search menu, 3-7

security

PRODUCT_USER_PROFILE table, 4-4

sending results to a file, 4-3

SET NEWPAGE command, 4-4

Set Options area, 3-8

SET TIMING command, 4-2

setting up, using LOGIN and GLOGIN, 4-3

shortcuts to starting SQL*Plus, 4-2

SPOOL command, 4-3

spool files, 4-3

spool menu command, 3-6

SPOOL OUT clause, not supported, 4-3

SQL*Plus

application window, 3-4

basic concepts, 1-3

command defined, 1-3

command line interface, 3-2

exiting, 3-10

installing, 2-2

installing online help, 2-2

menus, 3-5

overview, 1-2

prerequisites, viii

setting up environment from command line, 4-3

setting up environment from GUI, 3-8

shortcuts to starting, 4-2

using LOGIN and GLOGIN to setup, 4-3

Windows versions supported, vii

SQLPATH parameter, 4-3, A-2

SQLPLUS Environment Variable, A-3

START command, 4-3

Start menu location, for SQL*Plus, 3-3

starting SQL*Plus, 3-2

starting SQL*Plus GUI, 3-3

subkey, registry, A-2

system requirements, 2-2

system variables, setting, 3-8

---

T

table, defined, 1-3

tables, sample, 2-4

text editor

defining, 3-7

invoking, 3-7

TIMING command, 4-2

---

V

value

screen area, 3-8

value area, 3-8

---

W

Windows Operating Systems

note on Windows 2000 support, vii

versions supported, vii