Index

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

---

Symbols

$ command, 3-5

@ command, 3-4

@@ command, 3-4

---

A

access to sample tables, 3-2

AFIEDT.BUF, 2-7

ANSI escape sequences, warning about, 3-3

audience, SQL*Plus, xiv

---

B

basic concepts, 1-2

batch mode, not supported, 3-4

block, defined, 1-2

buffer

clearing your screen, 2-6

screen, 1-3

screen area, 2-8

SQL, 1-3, 2-5

---

C

cancelling an in-progress operation, 2-6

CD-ROM contents, 1-3

clearing your screen, 2-6

code conventions, used in this guide, xvi

command files

opening, 2-5

saving, 2-5

command keys, SQL*Plus GUI, 2-4

command line interface, 2-2

command, defined, 1-2

connect string, 2-3

contacting Oracle, v-??

copying text, 2-4, 2-6

---

D

DEMOBLD.SQL file, 3-2

DEMODROP.SQL file, 3-2

demonstration tables, 3-2

documentation

conventions used in this guide, xvi

related publications, xv

---

E

Edit menu, 2-6

editor

defining, 2-7

invoking, 2-7

environment

setting up SQL*Plus, 2-7, 3-3

Environment command, 2-7

error messages, interpreting, 3-3

EXIT command, 3-4

exiting SQL*Plus GUI, 2-6

---

F

File menu, 2-5

finding text, 2-7

---

G

GLOGIN.SQL file, 3-3

graphical user interface

menus, 2-5

starting, 2-2

---

H

Help menu, 2-9

helpinst.txt, xvi

HOME_NAME, defined, xvii

HOST command, 3-5

host string, 2-3

---

I

installing, 1-3

---

L

LOCAL parameter, 3-5

LOGIN.NEW file, warning about, 3-3

LOGIN.SQL file, 3-3

---

M

migrating, from Server Manager to SQL*Plus, 1-2

mouse, using to copy commands, 2-4

MS-DOS, accessing from SQL*Plus, 3-5

multiple Oracle homes

defined, xvii

---

O

Online Help

obtaining for SQL*Plus, xvi

operating systems, supported by SQL*Plus, xiii

Optimal Flexible Architecture (OFA), xvii

Options menu, 2-7

ORA error messages, 3-3

ORACLE_BASE, defined, xvii

ORACLE_HOME, defined, xvii

overview, 1-2

---

P

parameter

SQLPATH, 3-4, A-2

pasting text, 2-6

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

prerequisites, xiv

PRODUCT_USER_PROFILE table, 3-5

PUPBLD.SQL file, 3-5

---

Q

query results, defined, 1-3

query, defined, 1-3

---

R

REGEDIT.EXE, A-2

REGEDT32.EXE, A-2

registry, using, A-2

related publications, xv

report, defined, 1-3

rules, for Windows arguments, 2-2

Run menu command

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

---

S

sample tables, 3-2

saving, command files, 2-5

screen buffer area, 2-8

Search menu, 2-7

security

PRODUCT_USER_PROFILE table, 3-5

sending results to a file, 3-3

Server Manager, replaced by SQL*Plus, 1-2

SET NEWPAGE command, 3-5

Set Options area, 2-8

SET TIMING command, 3-3

setting up, using LOGIN and GLOGIN, 3-3

shortcuts to starting SQL*Plus, 3-2

SPOOL command, 3-3

spool files, 3-3

spool menu command, 2-5

SPOOL OUT clause, not supported, 3-4

SQL*Plus

basic concepts, 1-2

command defined, 1-2

command line interface, 2-2

installing, 1-3

menus, 2-5

overview, 1-2

prerequisites, xiv

setting up environment from command line, 3-3

setting up environment from GUI, 2-7

shortcuts to starting, 3-2

using LOGIN and GLOGIN to setup, 3-3

Windows versions supported, xiii

SQLPATH parameter, 3-4, A-2

START command, 3-4

starting SQL*Plus, 2-2

subkey, registry, A-2

system requirements, 1-3

system variables, setting, 2-7

---

T

table, defined, 1-3

tables, sample, 3-2

text editor

defining, 2-7

invoking, 2-7

TIMING command, 3-3

---

V

value

screen area, 2-8

value area, 2-8