SQL*Plus Getting Started -- Index

$ command, 4-4

@ command, 4-3

@@ command, 4-3

accessing sample tables, 2-4

add server to iSQL*Plus extension, 3-18, 3-19

AFIEDT.BUF

See editor

ANSI escape sequences, warning about, 4-3

automatic login, 4-2

basic concepts, 1-3

block, defined, 1-3

buffer

clearing your screen, 3-8

screen, 1-3

screen area, 3-10

SQL, 1-3, 3-7

C:\ORANT, defined, -xv

C:\ORAWIN95, defined, -xv

cancelling an in-progress operation, 3-8

CD-ROM contents, -ix, 2-2

Character Map Windows utility

choosing a font, 3-4, 3-15

clearing your screen, 3-8

command files

opening, 3-7

saving, 3-7

command keys, SQL*Plus Windows GUI, 3-6

command-line interface, 3-2

changing face and size, 3-3

Euro sign, 3-4

special character, 3-4

Windows Character Map utility, 3-4

commands

copying text, 3-6

defined, 1-3

finding text, 3-9

HOST, 4-4

pasting text, 3-8

SET NEWPAGE, 4-4

SET TIMING, 4-2

windows arguments, 3-2

configuring the iSQL*Plus extension, 3-17

connect string

Also See connect_identifier

iSQL*Plus extension, 3-18

connect_identifier, 3-5

context menu

iSQL*Plus extension, 3-16

copying text, 3-6, 3-8

CPY error messages, 4-2

demonstration tables, 2-4

Edit menu, 3-8

editor

defining, 3-8

invoking, 3-8

registry entries, A-2

environment

command, 3-9

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

SQLPLUS variable, A-4

error messages, interpreting, 4-2

Euro sign

command-line interface, 3-4

GUI, 3-13, 3-15

execute

iSQL*Plus extension, 3-18

exiting

SQL*Plus, 3-15

SQL*Plus GUI, 3-8

extension for iSQL*Plus, 3-16

file association

setting for Windows, 3-18

File menu, 3-7

finding text, 3-9

font

changing face and size in command-line, 3-3

changing face and size in GUI, 3-12, 3-13

changing in GUI, 3-12

euro sign in command-line, 3-4

fixed pitch TrueType, 3-13

Oracle home, 3-13

setting default in GUI, A-3

setting default size in GUI, A-3

setting default subset in GUI, A-3

special character in command-line, 3-4

Windows Character Map utility, 3-4

GLOGIN.SQL file, 4-3

graphical user interface

See GUI

GUI

changing face and size, 3-12, 3-13

changing font, 3-12

menus, 3-7

Windows Character Map utility, 3-15

help

accessing online help, 2-3

installation prerequisites, 2-2

installing, 2-2

menu, 3-10

HOST command, 4-4

host string, 3-5

installing SQL*Plus online help, 2-2

iSQL*Plus

add a server, 3-18, 3-19

configuring the extension, 3-17

defining server connect string, 3-18

defining server mode, load or execute, 3-18

defining server name, 3-18

defining server URL, 3-17

Extension for Windows, 3-16

Extension for Windows registry entries, A-4

extension, setting file association, 3-18

iSQL*Plus registry entry, A-4

modify a server definition, 3-20

remove a server, 3-18

remove a server definition, 3-20

Server registry entry, A-4

setting language in extension, 3-18

language, setting for iSQL*Plus extension, 3-18

load, iSQL*Plus extension, 3-18

LOCAL parameter, 4-5

Log On dialog, 3-4

login, automatic, 4-2

LOGIN.SQL file, 4-3

menus, Windows GUI, 3-7

modify iSQL*Plus extension server definition, 3-20

mouse, using to copy command, 3-6

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

multiple Oracle homes, specifying font, 3-13

name, iSQL*Plus extension, 3-18

net_service_name

See connect_identifier

online help

accessing online help, 2-3

installation prerequisites, 2-2

installing, 2-2

obtaining for SQL*Plus, 1-3, 2-2

operating systems, supported by SQL*Plus, -vii

Options menu, 3-9

ORA error messages, 4-2

ORACLE home

explained, -xv

Oracle home

specifying font, 3-13

ORACLE_BASE

explained, -xv

overview, 1-2

parameter

SQLPATH, 4-3, A-2

SQLPLUS_FONT, 3-12, A-3

SQLPLUS_FONT_CHARSET, A-3

SQLPLUS_FONT_SIZE, 3-12, A-3

pasting text, 3-8

PLS error messages, 4-2

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

prerequisites, installing online help, 2-2

PRODUCT_USER_PROFILE table, 4-4

PUPBLD.SQL file, 4-4

query

defined, 1-3

results defined, 1-3

REGEDIT.EXE, A-2

REGEDT32.EXE, A-2

registry

editor, 3-12, A-2, A-3

iSQL*Plus entry, A-4

iSQL*Plus Extension for Windows entries, A-4

iSQL*Plus Server entry, A-4

REGEDIT.EXE, A-2

REGEDT32.EXE, A-2

SQLPATH entry, 4-3, A-2

SQLPLUS_FONT entry, 3-12, A-3

SQLPLUS_FONT_CHARSET entry, A-3

SQLPLUS_FONT_SIZE entry, 3-12, A-3

remove

iSQL*Plus extension server, 3-20

server from iSQL*Plus extension, 3-18

report, defined, 1-3

rules, for Windows arguments, 3-2

Run menu command, 3-8

sample tables, 2-4

saving, command files, 3-7

screen buffer area, 3-10

script

See command file

Search menu, 3-9

security

PRODUCT_USER_PROFILE table, 4-4

sending results to a file, 4-3

server

adding to iSQL*Plus, 3-18, 3-19

defining iSQL*Plus connect string, 3-18

defining iSQL*Plus mode, load or execute, 3-18

defining iSQL*Plus name, 3-18

defining iSQL*Plus url, 3-17

modifying an iSQL*Plus server definition, 3-20

server (cont)

removing an iSQL*Plus server definition, 3-20

removing from iSQL*Plus extension, 3-18

SET

See alsoWindows GUI

setting system variables

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

SP2 error messages, 4-2

special characters

choosing a font, 3-4

Euro sign, 3-4, 3-13, 3-15

using, 3-4, 3-15

SPOOL command, 4-3

spool files, 4-3

spool menu command, 3-7

SPOOL OUT clause, not supported, 4-3

SQL buffer, 3-7

SQL*Plus

application window, 3-5

basic concepts, 1-3

command defined, 1-3

command-line interface, 3-2

exiting, 3-15

installing, 2-2

installing online help, 2-2

menus, 3-7

setting up environment, 4-3

setting up environment from GUI, 3-9

shortcuts to starting, 4-2

starting, 3-2

using LOGIN and GLOGIN to setup, 4-3

Windows versions supported, -vii

SQL*Plus Windows GUI

changing face and size, 3-12, 3-13

changing font, 3-12

SQLPATH registry entry, 4-3, A-2

SQLPLUS Environment Variable, A-4

SQLPLUS_FONT parameter, 3-12

SQLPLUS_FONT registry entry, A-3

SQLPLUS_FONT_CHARSET registry entry, A-3

SQLPLUS_FONT_SIZE parameter, 3-12

SQLPLUS_FONT_SIZE registry entry, A-3

START command, 4-3

Start menu, starting 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

screen buffer, 3-10

Set Options area, 3-9

setting, 3-9

value area, 3-9

tables

defined, 1-3

demonstration, 2-4

text editor

defining, 3-8

invoking, 3-8

TIMING command, 4-2

TNS error messages, 4-2

URL, iSQL*Plus extension, 3-17

value area, 3-9

value screen area, 3-9

Windows

extension for iSQL*Plus, 3-16

setting the file association, 3-18

versions supported, -vii, -viii

Windows GUI

application window, 3-5

cancelling, 3-8

changing face and size, 3-12, 3-13

changing font, 3-12

Windows GUI (cont)

command keys, 3-6

exiting, 3-8

File menu, 3-7

Log On dialog, 3-4

menus, 3-7

setting system variables, 3-9

starting SQL*Plus, 3-4

Windows Operating Systems

versions supported, -viii

Index

Symbols

A

B

C

D

E

F

G

H

I

L

M

N

O

P

Q

R

S

T

U

V

W