iSQL Plus. User's Guide and Reference

✍ Scribed by Watt S.

• Year: 2001
• Tongue: English
• Leaves: 264
• Edition: release 9.0.1
• Category: Library

✦ Synopsis

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 iSQLPlus......Page 19
iSQLPlus Architecture......Page 20
Oracle9i......Page 21
2 Configuring iSQLPlus......Page 23
Installation......Page 24
Adding Proxy Server Exceptions......Page 25
Configuring the iSQLPlus Server......Page 26
Changing the Default Cascading Style Sheet......Page 27
Enabling or Disabling iSQLPlus......Page 28
Starting and Stopping the Oracle HTTP Server......Page 29
iSQLPlus 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 iSQLPlus User Interface......Page 37
Connection Identifier:......Page 38
Clear......Page 39
Browse.........Page 40
Save Script......Page 41
Cancel......Page 42
4 Using iSQLPlus......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 iSQLPlus......Page 51
5 Command Reference......Page 53
SQLPlus 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 SQLPlus Error Messages......Page 177
SQLPlus Error Messages and Codes......Page 178
iSQLPlus 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 SQLPlus, 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