SQL*Plus Getting Started
Release 8.1.7 for Windows

Part Number A82954-01

Library

Product

Contents

Go to previous page

Index

A  B  C  D  E  F  G  H  I  L  M  N  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-8
ANSI escape sequences, warning about, 4-3
audience, SQL*Plus, viii

B

basic concepts, 1-2
block, defined, 1-2
buffer
clearing your screen, 3-8
screen, 1-3
screen area, 3-9
SQL, 1-3, 3-7

C

cancelling an in-progress operation, 3-7
CD-ROM contents, ix, 2-2
Character Map Windows utility
choosing a font, 3-3, 3-13
clearing your screen, 3-8
code conventions, used in this guide, x
command files
opening, 3-6
saving, 3-6
command keys, SQL*Plus Windows GUI, 3-6
command line interface, 3-2
changing face and size, 3-3
Euro sign, 3-3
special character, 3-3
Windows Character Map utility, 3-3
command, defined, 1-2
connect_identifier, 3-4
connect_string
See
copying text, 3-5, 3-8

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-8
editor
defining, 3-8
invoking, 3-8
environment
command, 3-9
setting up SQL*Plus, 3-9, 4-3
SQLPLUS variable, A-3
error messages, interpreting, 4-2
Euro sign
command line interface, 3-3
GUI, 3-12, 3-13
exiting SQL*Plus, 3-14
exiting SQL*Plus GUI, 3-7

F

File menu, 3-6
finding text, 3-8
font
changing face and size in CLI, 3-3
changing face and size in GUI, 3-11, 3-12
changing in GUI, 3-11
fixed pitch TrueType, 3-12
Oracle Home, 3-12

G

GLOGIN.SQL file, 4-3
graphical user interface
See
GUI
changing face and size, 3-11, 3-12
changing font, 3-11
menus, 3-6
starting, 3-4
Windows Character Map utility, 3-13

H

help
accessing online help, 2-3
installation prerequisites, 2-2
installing, 2-2
Help menu, 3-10
HOME_NAME, defined, xi
HOST command, 4-4
host string, 3-4

I

installing
SQL*Plus online help, 2-2

L

LOCAL parameter, 4-5
Log On dialog, 3-4
LOGIN.SQL file, 4-3

M

menus
GUI, 3-6
mouse, using to copy commands, 3-5
MS-DOS, accessing from SQL*Plus, 4-4
multiple Oracle homes
defined, xi
specifying font, 3-12

N

net_service_name
See

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-9
ORA error messages, 4-2
Oracle Home
specifying font, 3-12
ORACLE_BASE, defined, xi
ORACLE_HOME, defined, xi
overview, 1-2

P

parameter
SQLPATH, 4-3, A-2
SQLPLUS_FONT, 3-11, A-3
SQLPLUS_FONT_SIZE, 3-11, A-3
pasting text, 3-8
PL/SQL, relation to SQL*Plus, 1-2
prerequisites
installing online help, 2-2
SQL*Plus, viii
PRODUCT_USER_PROFILE table, 4-4
PUPBLD.SQL file, 4-4

Q

query
defined, 1-3
results defined, 1-3

R

REGEDIT.EXE, A-2
REGEDT32.EXE, A-2
registry
editor, 3-11, A-2, A-3
SQLPATH entry, 4-3, A-2
SQLPLUS_FONT entry, 3-11, A-3
SQLPLUS_FONT_SIZE entry, 3-11, A-3
report, defined, 1-3
rules, for Windows arguments, 3-2
Run menu command
lists and executes SQL and PL/SQL, 3-7

S

sample tables, 2-4
saving, command files, 3-6
screen buffer area, 3-9
Search menu, 3-8
security
PRODUCT_USER_PROFILE table, 4-4
sending results to a file, 4-3
SET NEWPAGE command, 4-4
Set Options area, 3-9
SET TIMING command, 4-2
setting up, using LOGIN and GLOGIN, 4-3
shortcuts to starting SQL*Plus, 4-2
special characters
choosing a font, 3-3
Euro sign, 3-3, 3-12, 3-13
using, 3-3, 3-13
SPOOL command, 4-3
spool files, 4-3
spool menu command, 3-7
SPOOL OUT clause, not supported, 4-3
SQL*Plus
application window, 3-5
basic concepts, 1-2
command defined, 1-2
command line interface, 3-2
exiting, 3-14
installing, 2-2
installing online help, 2-2
menus, 3-6
overview, 1-2
prerequisites, viii
setting up environment from command line, 4-3
setting up environment from GUI, 3-9
shortcuts to starting, 4-2
using LOGIN and GLOGIN to setup, 4-3
Windows versions supported, vii
SQL*Plus Windows GUI
changing face and size, 3-11, 3-12
changing font, 3-11
SQLPATH parameter, 4-3, A-2
SQLPLUS Environment Variable, A-3
SQLPLUS_FONT parameter, 3-11, A-3
SQLPLUS_FONT_SIZE parameter, 3-11, A-3
START command, 4-3
Start menu location, for SQL*Plus, 3-4
starting
SQL*Plus, 3-2
SQL*Plus Windows GUI, 3-4
subkey, registry, A-2, A-3
system requirements, 2-2
system variables, setting, 3-9

T

tables
defined, 1-2
demonstration, 2-4
text editor
defining, 3-8
invoking, 3-8
TIMING command, 4-2

V

value area, 3-9
value screen area, 3-9

W

Windows GUI
changing face and size, 3-11, 3-12
changing font, 3-11
Windows Operating Systems
versions supported, vii

Go to previous page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents