1. Index

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  

A

  • abnormal termination, automatic rollback E.6.5
  • active set 4.4
  • ALLOCATE command E.4
  • allocating, cursors E.4.2
  • ANSI/ISO SQL
  • application development process 2.2
  • array 9.1
  • array, elements 9.3
  • array, operations 2.1.8
  • array fetch 9.5.1
  • ARRAYLEN statement 5.5.1
  • ASACC option 6.7.1
  • ASSUME SQLCODE option 6.7.2
  • AT clause
  • AUTO_CONNECToption 6.7.3
  • automatic logon 3.11.3

B

C

  • callback, user exit 11.13.1
  • CHAR_MAP precompiler option 6.7.4
  • character strings, multi-byte 3.10.1
  • CHAR column, maximum width 3.4.2
  • CHAR datatype
  • CHARF data type, external 3.4.15
  • CHARF data type specifier
    • using in TYPE statement 3.8.4
    • using in VAR statement 3.8.4
  • CHARZ data type 3.4.16
  • chatracter sets, multi byte 3.10
  • child cursor 5.6
  • CINCR precompiler option 6.7.5
  • CLOSE_ON_COMMIT
    • precompiler option 6.7.6
  • CLOSE command E.5
  • CLOSE statement 4.4.4, 4.5.5
  • closing, cursors E.5.1
  • CMAX precompiler option 6.7.7
  • CMIN precompiler option 6.7.8
  • CNOWAIT precompiler option 6.7.9
  • code page 3.9
  • CODE precompiler option 6.7.10
  • column, ROWLABEL 3.4.12
  • comment 10.12.5
  • COMMENT clause, of COMMIT command E.6.4
  • commit 7.2
    • automatic 7.3
    • explicit versus implicit 7.3
  • COMMIT command E.6
  • commiting, transactions E.6.2
  • COMMIT statement 7.4
  • COMMON_PARSER precompiler option 6.7.12
  • COMMON NAME option 6.7.11
  • communication over a network 3.11.1
  • COMP_CHARSET precompiler option 6.7.13, 6.7.14
  • compilation 6.10
  • compliance, ANSI/ISO 1.6
  • concurency 7.1
  • concurrent logons 3.11
  • conditional precompilation 6.8
  • CONFIG option 6.4.7
  • CONFIG precompiler option 6.7.15
  • configuration file
    • system versus user 6.4.5
  • configuration files
  • connection
  • CONNECT statement
  • CONTINUE action 8.4.26
  • CONTINUE option, of WHENEVER statement E.26.4
  • conventions
  • coventions
    • description
  • CPOOL precompiler option 6.7.16
  • CPP_SUFFIX precompiler option 6.7.17
  • CPP_SUFFIX precompiler options 6.7.17
  • CREATE PROCEDURE statement 5.7.1
  • creating, savepoints E.22.1
  • CTIMEOUT precompiler option 6.7.18
  • CURRENT of cluase 4.4.5
  • current row 2.1.10
  • CURRVAL psuedocolumn 3.4.11
  • cursor 4.4
  • cursor, scope 4.4.1
  • cursor cache 5.6, 8.5.4, E.4.1
    • gathering stastics about 8.5.16
  • cursor chache
  • cursors
  • cursor varaible

D

  • database link
  • database links
  • data definition language 4.1.1
  • data definition language (DDL)
  • data integrity 7.1
  • data manipulation language (DML) 4.3
  • data type
    • host-languages 3.6
    • internal versus external 2.1.7
    • user defined 3.6
  • data type conversion 3.5
    • between internal and external datatypes 3.5
  • data type equivalencing 3.8
  • Date data type
  • DB2_ARRAY precompiler option 6.7.19
  • DBMS option 6.7.20
  • deadlock 7.1
  • DECIMAL data type 3.4.18
  • declarartion
    • host array 9.3
    • host variable 3.6
  • declaration
  • declarative SQL statements
    • using in transactions 7.3
  • Declarative SQL statements 2.1.2
  • declare CURSOR command E.8.1
  • declare CURSOR statement 3.11.4
  • declare DATABASE directive E.9.1
  • declare section 3.1
  • DECLARE statement
  • declare STATEMENT command E.10.1
  • DECLARE STATEMENT statement
  • DECLARE TABLE command E.11.1
  • declare TABLE statement
    • need for with AT clause 3.11.4
  • DECLARE TABLE statement
    • need for with AT clause 3.11.4
    • using with the SQL CHECK option D.3.3
  • DEF_SQLCODE precompiler option 6.7.21
  • default, setting of LITDELIM option 6.7.40
  • default connection 3.11.2
  • default database 3.11.2
  • DEFINE option 6.7.22
  • definition 2.1.10
  • delete cascaade 8.4.17
  • DELETE command E.12.1
    • embedded SQL examples E.12.6
  • DELETE statement
    • using SQLERRD(3) filed 9.10
    • WHERE clause 4.3.6
  • DESCRIBE command E.13.1
  • DESCRIBE statement, using in dynamic SQL Method 4 10.10.2
  • directory 3.2
    • current 3.2
    • path for INCLUDE files 3.2
  • DISPLAY data type 3.4.19
  • distributed procesing 3.11
  • DO action 8.4.27
  • DO option, of WHENEVER command E.26.4
  • DTP model 3.13
  • dummy host variables 10.4
  • DURATION precompiler option 6.7.24
  • dynamic PL/SQL 10.12
  • dynamic SQL
  • dynamic SQL Method1
  • dynamic SQL Method 1
  • dynamic SQL method 2
    • using the DECLARE STATEMENT Statement 10.11
  • dynamic SQL Method 2
  • dynamic SQL method 3
    • using the DECLARE STATEMENT Statement 10.11
  • dynamic SQL Method 3
  • dynamic SQL Method4
  • dynamic SQL method 4
    • using the DECLARE STATEMENT Statement 10.11
  • dynamic SQL Method 4
  • dynamic SQL statement 10.1
    • binding of host variables 10.5
    • how processed 10.5
    • requirements 10.4
    • using host arrays 10.11.1
    • using placeholders 10.4

E

F

G

  • GENXTB form, running 11.10
  • globalizaton support 3.9
    • multibyte charecter strings 3.10
  • globalizaton support parameter
    • currency 3.9
    • DATE FORMAT 3.9
    • DATE LANGUAGE 3.9
    • ISO CURRENCY 3.9
    • LANGUAGE 3.9
    • NUMERIC CHARACTERS 3.9
    • SORT 3.9
    • TERRITORY 3.9
  • GOTO action 8.4.28
  • GOTO optio, of WHENEVER command E.26.4
  • guidelines
  • guielines
    • indicator variables 3.7.3

H

  • HEADER precompiler option 6.7.31
  • heap 8.5.4
  • hint, optimizer C.5.1
  • hints
  • HOLD_CURSOR precompiler option 6.7.32
  • HOLD CURSOR option
    • of Oracle precompilers E.5.2
  • host array 9.1
    • advantages 9.2
    • declaring 9.3
    • dimensions 9.3.1
    • maximum size 9.3
    • referencing 9.3.2
    • restrictions 9.5.3, 9.5.6, 9.5.7
    • using dynamic SQL statement 10.11.1
    • using in the DELETE statement 9.5.8
    • using in the INSERT statement 9.5.6
    • using in the SELECTstatement 9.5
    • using in the UPDATE statement 9.5.7
    • using in the WHERE clause 9.8
    • using to improve performance C.3
    • when not allowed 9.4
  • host language 2.1.1
  • host-language datatype 3.6
  • host option 6.7.33
  • host program 2.1.1
  • host varaible
    • in OPEN command E.19.4
    • multi-byte charecter strings 3.10.4
    • undeclare 3.1
    • using in EXEC TOOLS statement 11.13
    • using in PL/SQL 5.3
  • host variable 4.1
  • host variables

I

J

K

L

M

  • MAX_ROW_INSERT precompiler option 6.7.46
  • MAXLITERAL option 6.7.44
  • MAXOPENCURSORS option 6.7.45
    • using for separate precompilation 6.9.1
    • what it affects C.8
  • MLSLABEL data type 3.4.6
  • mode, parameter 5.1.5
  • MODE option 6.7.47
  • monitor, transaction processing 3.13
  • multi-byte character sets 3.10.4
  • MULTISUBPROG option 6.7.48

N

  • namespaces, reserved by Oracle B.4
  • naming conventions
  • naming of database objects E.3.5
  • NATIVE
  • NATIVE_TYPES precompiler option 6.7.49
  • native interface 3.13
  • network
  • NEXTVAL, psuedocolumn 3.4.11
  • nibble 3.5.2
  • NIST, compliance 1.6
  • NLS_CHAR precompiler option 6.7.50
  • NLS_LOCAL precompiler option 6.7.51
  • node, definition 3.11.2
  • notation
    • convention
  • NOWAIT
    • parameter 7.9.3
    • using the LOCK TABLE statement 7.9.3
  • null
  • null-terminated string 3.4.30
  • NUMBER data type

O

P

Q

  • query 4.3
    • association with cursor 4.4
    • multirow 4.3
    • single-row versus multirow 4.3.1

R

  • RAW column, maximum width 3.4.8
  • RAW datatype
  • read consistency 7.1
  • READ ONLY parameter, using in SET TRANSACTION 7.8
  • read-only transaction 7.8
  • record, user-defined 5.1.8
  • reference
    • host array 9.3.2
    • host variable 3.6
    • indicator variable 3.7
  • RELEASE_CURSOR option 6.7.61
    • of Oracle Precompilers E.5.5
    • using to improve performance C.8.6
  • RELEASE option 7.7
    • COMMIT statement 7.4
    • omitting 7.7
    • restrictions 7.6
    • ROLLBACK statement 7.5
  • remote database, declaration of E.9.1
  • reserved words B.1
  • resource manager 3.13
  • retrieving rows from a table, embedded SQL E.23.1
  • return code 11.7
  • rollabck
  • rollback
  • roll back
    • to a savepoint E.22.1
    • to the same savepoint multiple times E.21.5
  • ROLLBACK command E.21
  • rollback segment 7.1
  • ROLLBACK statement
    • effects 7.5
    • example 7.5
    • RELEASE option 7.5
    • TO SAVEPOINT clause 7.6
    • using in a PL/SQL block 7.12.3
    • using in error-handling routines 7.5
    • where to place 7.5
  • ROLLBACK Statement 7.5
  • rolling back, transactions E.21
  • ROWID datatype
  • ROWID pseudocolumn 3.4.11
    • using to mimic CURRENT OF 7.10, 9.9
  • ROWLABEL column 3.4.12
  • row lock
    • acquiring with FOR UPDATE OF 7.9.1
    • using to improve performance C.7
    • when acquired 7.9.2
    • when released 7.9.2
  • ROWNUM pseudocolumn 3.4.11
  • rows
    • fetching from cursors E.17
    • inserting into tables and views E.18
    • updating E.24
  • rows-processed count 8.4.17
    • using in error reporting 8.4.8
  • RUNOUTLINE precompiler option 6.7.62

S

  • sample database table
    • DEPT table 2.4
    • EMP table 2.4
  • savepoint 7.6
  • savepoint, when erased 7.6
  • SAVEPOINT command E.22
  • savepoints, creating E.22
  • SAVEPOINTS parameter 7.6
  • SAVEPOINT statement 7.6
  • scale 3.4.7
  • scope
    • of DECLARE STATEMENT command E.10.5
    • of precompiler options 6.5
    • of the EXEC ORACLE statement 6.4.4
    • WHENEVER statement 8.4.31
  • search condition 4.3.7
    • using in the WHERE clause 4.3.7
  • SELECT_ERROR option 6.7.63
  • SELECT command E.23
    • embedded SQL examples E.23.6
  • select descriptor, information in 10.10
  • select list 4.3.1
  • SELECT statement 4.3.1
    • available clauses 4.3.2
    • example 4.3.1
    • INTO clause 4.3.1
    • using host arrays 9.5
    • using the SQLERRD(3) field 9.10
  • semantic checking D.1
    • enabling D.3.1
    • using the SQLCHECK option D.2
  • separate precompilation 6.9
  • session 7.1
  • sessions, beginning E.7
  • SET clause 4.3.5
  • SET TRANSACTION statement 7.8
    • example 7.8
    • READ ONLY parameter 7.8
    • restrictions 7.8
  • snapshots 7.1
  • SQL_CURSOR E.4.2
  • SQL, summary of commands E.1
  • SQL*Connect, using ROWID datatype 3.4.29
  • SQL*Forms
    • Display Error screen 11.7
    • IAP Constants 11.7.1
    • returning values to 11.7
    • Reverse Return Code switch 11.7
    • user exit 11.1
  • SQL*Net
    • concurrent logons 3.11
    • connection syntax 3.11.1
    • function of 3.11.1
    • using to connect to Oracle 3.11
  • SQL*Plus 1.3
  • SQL92
  • SQLCA 3.3, 8.4
    • components set for a PL/SQL block 8.4.20
    • declaring 8.4.1
    • explicit versus implicit checking 8.2.2
    • fields 8.4.11
    • interaction with Oracle 3.3
    • using in separate precompilations 6.9.1
    • using more than one 8.4
    • using with SQL*Net 8.4
  • SQLCABC filed 8.4.13
  • SQLCAID field 8.4.12
  • SQLCHECK option 6.7.64
    • restrictions D.2
    • usage notes for 6.7.66
    • using the DECLARE TABLE statement D.3.1
    • using to check syntax D
  • SQLCHECK precompiler option 6.7.66
  • SQL code, returned by SQLGLS function 8.4.33
  • SQLCODE field 8.4.14
  • SQLCODE status variable 8.3
  • SQLCODE variable, interpreting values of 8.3.10
  • SQL Communications Area 8.4
  • SQL Descriptor Area 10.10.1
  • SQLERRD 8.4.17
  • SQLERRD(3) field 9.10
    • purpose 8.4.8
    • using with the FETCH statement 9.10
  • SQLERRD(3) filed
    • using with batch fetch 9.5.2
  • SQLERRD(5) field 8.4.17
  • SQLERRMC field 8.4.15
  • SQLERRML field 8.4.15
  • SQLERROR condition 8.4.24
  • SQLFC parameter 8.4.33
  • SQLGLM function 8.4.21
  • SQLGLS function
  • SQLIEM function
  • SQLLDA routine 3.12.1
  • SQL standards conformance 1.6.1
  • SQL statement
    • controlling transactions 7.2
    • executable versus declarative 2.1.2
    • optimizing to improve performance C.5
    • static versus dynamic 2.1.4
    • using to control a cursor 4.3, 4.4
    • using to manipulate Oracle data 4.3
  • SQLSTATE status variable 8.2
    • class code 8.3.11
    • coding scheme 8.3.11
    • declaring 8.3.7
    • error handling
      • SQLSTATE status variable 8.3
    • interpreting values 8.3.11
    • predefined status code and conditions 8.3.11
    • subclass code 8.3.11
  • SQLSTM parameter 8.4.33
  • SQLWARN 8.4.18
  • SQLWARN flags 8.4.18
  • SQLWARNING condition 8.4.23
  • statement-level rollback 7.5.1
    • breaking deadlocks 7.5.1
  • status code 8.4.6
  • STMLEN parameter 8.4.33
  • STMT_CACHE
  • STOP action 8.4.29
  • stored subprogram 5.7
    • calling 5.7.2
    • creating 5.7.1
    • packaged versus standalone 5.7
    • stored versus inline C.4
    • using to improve performance C.4
  • STRING datatype 3.4.30
  • subprogram, PL/SQL 5.1.4, 5.7
  • subquery 4.3.4
  • syntactic checking D.1
  • syntax, embedded SQL 2.1.3
  • syntax diagram
    • description of E.3
    • how to read E.3
    • how to use E.3
    • symbols used in E.3
  • SYSDATE function 3.4.11
  • system failure, effect on transactions 7.3
  • System Global Area (SGA) 5.7

T

  • table lock
  • tables
    • inserting rows into E.18
    • updating rows in E.24
  • THREADS
  • TO SAVEPOINT clause 7.6
    • restrictions 7.6
    • using in ROLLBACK statement 7.6
  • trace facility, using to improve performance C.5.3
  • transaction 7.2
    • subdividing with savepoints 7.6
    • undoing 7.5
    • undoing parts of 7.6
    • when rolled back automatically 7.3, 7.5
  • transaction, contents 2.1.11, 7.3
  • transaction, read-only 7.8
  • transaction processing
  • transactions
  • truncated value 5.4.2
  • truncation error, when generated 4.2.7
  • tuning, performance C.1
  • TYPE_CODE
  • TYPE statement, using the CHARF datatype specifier 3.8.4

U

  • UID function 3.4.11
  • unconditional delete 8.4.18
  • undo a transaction E.21.1
  • UNSAFE_NULL option 6.7.69, A.1
  • UNSIGNED datatype 3.4.31
  • update cascade 8.4.17
  • UPDATE command E.24
    • embedded SQL examples E.24.6
  • UPDATE statement 4.3.5
  • updating, rows in tables and views E.24
  • user-defined datatype 3.6
  • user-defined record 5.1.8
  • user exit 11.1
    • calling from a SQL*Forms trigger 11.5
    • common uses 11.2
    • example 11.8
    • guidelines 11.12
    • linking into IAP 11.11
    • meaning of codes returned by 11.7
    • naming 11.12.1
    • passing parameters 11.6
    • requirements for variables 11.4.1
    • running the GENXTB form 11.10
    • statements allowed in 11.4
    • steps in developing 11.3
    • using EXEC IAF statements 11.4.2
    • using EXEC TOOLS statements 11.13
    • using the WHENEVER statement 11.7.3
  • USER function 3.4.11
  • USERID option 6.7.70
    • using with the SQLCHECK option D.3.1
  • user session 7.1
  • USING clause
    • CONNECT statement 3.11.4
    • using indicator variables 10.8.1
    • using in the EXECUTE statement 10.8.1
  • using dbstring, SQL*Net database id specification E.7.4

V

W

X