iSQL Plus. User’s Guide and Reference

Watt S.

iSQL Plus User’s Guide and Reference is intended for end users and system administrators who perform the following tasks:■ Enter, edit, run store, retrieve, and save SQL commands and PL/SQL blocks■ Calculate, store, and print query results.■ List column definitions for any table.■ Access and copy data between databases.■ Perform database administration.To use this document, you need a basic understanding of the SQL databaselanguage. If you do not have any familiarity with this database tool, you should refer to the Oracle 9i 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 7
Preface……Page 9
1 Introduction to iSQL*Plus……Page 19
iSQL*Plus Architecture……Page 20
Oracle9i……Page 21
2 Configuring iSQL*Plus……Page 23
Installation……Page 24
Adding Proxy Server Exceptions……Page 25
Configuring the iSQL*Plus Server……Page 26
Changing the Default Cascading Style Sheet……Page 27
Enabling or Disabling iSQL*Plus……Page 28
Starting and Stopping the Oracle HTTP Server……Page 29
iSQL*Plus Security……Page 30
Enabling User Security……Page 31
Adding Entries to an Oracle HTTP Server Authentication File……Page 32
Logging In Using Oracle HTTP Server Authentication……Page 33
Web Browser – client tier:……Page 34
Oracle HTTP Server – middle tier:……Page 35
Oracle9i – database tier:……Page 36
3 The iSQL*Plus User Interface……Page 37
Connection Identifier:……Page 38
Clear……Page 39
Browse………Page 40
Save Script……Page 41
Cancel……Page 42
4 Using iSQL*Plus……Page 43
Entering Statements……Page 44
Loading Scripts……Page 45
The Define Substitution Variables Screen……Page 46
Cancel……Page 47
Creating Dynamic Reports……Page 48
Exiting iSQL*Plus……Page 51
5 Command Reference……Page 53
SQL*Plus Command Summary……Page 54
@ (“at” sign)……Page 57
@@ (double “at” sign)……Page 59
/ (slash)……Page 61
ARCHIVE LOG……Page 62
ATTRIBUTE……Page 65
BREAK……Page 67
BTITLE……Page 72
CLEAR……Page 73
COLUMN……Page 75
COMPUTE……Page 86
CONNECT……Page 92
COPY……Page 94
DEFINE……Page 98
DESCRIBE……Page 100
DISCONNECT……Page 106
EXECUTE……Page 107
HELP……Page 108
LIST……Page 109
PRINT……Page 111
PROMPT……Page 113
RECOVER……Page 114
REMARK……Page 121
REPFOOTER……Page 122
REPHEADER……Page 124
RUN……Page 127
SET……Page 128
SHOW……Page 148
SHUTDOWN……Page 153
START……Page 155
STARTUP……Page 157
TIMING……Page 160
TTITLE……Page 162
UNDEFINE……Page 166
VARIABLE……Page 167
WHENEVER OSERROR……Page 174
WHENEVER SQLERROR……Page 175
A SQL*Plus Error Messages……Page 177
SQL*Plus Error Messages and Codes……Page 178
iSQL*Plus Error Messages……Page 209
COPY Command Messages……Page 213
B Security……Page 215
Creating the PUP Table……Page 216
Description and Use of PUP Columns……Page 217
Disabling SQL*Plus, SQL, and PL/SQL Commands……Page 218
Creating and Controlling Roles……Page 220
Disabling User Roles……Page 221
C Unsupported SQL*Plus Commands……Page 223
Glossary……Page 225
Index……Page 251