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 1
  • active set
    • changing 1 , 2
  • ALLOCATE command 1
  • allocating, cursors 1
  • ANSI/ISO SQL
    • compliance 1
    • extensions 1
  • application development process 1
  • array 1
  • array, elements 1
  • array, operations 1
  • array fetch 1
  • ARRAYLEN statement 1
  • ASACC option 1
  • ASSUME SQLCODE option 1
  • AT clause
    • CONNECT statement 1
    • DECLARE CURSOR statement 1
    • DECLARE STATEMENT statement 1
    • EXECUTE IMMEDIATE statement 1
    • of COMMITcommand 1
    • of DECLARE CURSOR command 1
    • of DECLARE STATEMENT command 1
    • of EXECUTE command 1
    • of EXECUTE IMMEDIATE command 1
    • of INSERTcommand 1
    • of SAVEPOINT command 1
    • of UPDATE command 1
    • restrictions 1
  • AUTO_CONNECToption 1
  • automatic logon 1

B

  • batch fetch
    • example 1
    • number of rows returned 1
  • bind descriptor, information in 1
  • binding 1
  • bind variable 1 , 2
  • blank padding, in multi-byte character strings 1
  • block data subprogram, used by precompiler 1

C

  • callback, user exit 1
  • CHAR_MAP precompiler option 1
  • character strings, multi-byte 1
  • CHAR column, maximum width 1
  • CHAR datatype
    • external 1
    • internal 1
  • CHARF data type, external 1
  • CHARF data type specifier
    • using in TYPE statement 1
    • using in VAR statement 1
  • CHARZ data type 1
  • chatracter sets, multi byte 1
  • child cursor 1
  • CINCR precompiler option 1
  • CLOSE_ON_COMMIT
    • precompiler option 1
  • CLOSE command
    • examples 1
  • CLOSE statement
    • example 1
  • closing, cursors 1
  • CMAX precompiler option 1
  • CMIN precompiler option 1
  • CNOWAIT precompiler option 1
  • code page 1
  • CODE precompiler option 1
  • column, ROWLABEL 1
  • comment 1
  • COMMENT clause, of COMMIT command 1
  • commit
    • automatic 1
    • explicit versus implicit 1
  • COMMIT command
    • ending a transaction 1
    • examples 1
  • commiting, transactions 1
  • COMMIT statement
    • effects 1
    • example 1
    • RELEASE option 1
    • using PL/SQL block 1
    • where to place 1
  • COMMON_PARSER precompiler option 1
  • COMMON NAME option 1
  • communication over a network 1
  • COMP_CHARSET precompiler option 1
  • compilation 1
  • compliance, ANSI/ISO 1
  • concurency 1
  • concurrent logons 1
  • conditional precompilation
    • defining symbols 1
    • example 1
  • CONFIG option 1
  • CONFIG precompiler option 1
  • configuration file
    • system versus user 1
  • configuration files
    • advantages 1
  • connection
    • concurrent 1
    • default versus non-default 1
    • implicit 1
  • CONNECT statement
    • AT clause 1
    • enabling a semantic check 1
    • USING clause 1
  • CONTINUE action 1
  • CONTINUE option, of WHENEVER statement 1
  • conventions 1
  • coventions
    • description 1
  • CPOOL precompiler option 1
  • CPP_SUFFIX precompiler option 1
  • CPP_SUFFIX precompiler options 1
  • CREATE PROCEDURE statement 1
  • creating, savepoints 1
  • CTIMEOUT precompiler option 1
  • CURRENT of cluase
    • example 1
    • restrictions 1
  • current row 1
  • CURRVAL psuedocolumn 1
  • cursor
    • allocating 1
    • association with query 1
    • child 1
    • closing 1
    • declaring 1
    • effects on performance 1
    • explicit versus implicit 1
    • naming 1
    • parent 1
    • reopening 1 , 2
    • restricted scope of 1
    • restrictions 1
    • using for multiple row query 1
    • using more than one 1
  • cursor, scope 1
  • cursor cache
    • gathering stastics about 1
  • cursor chache
    • purpose 1
  • cursors
    • fetching rows from 1
    • opening 1
  • cursor varaible
    • opening 1

D

  • database link
    • defining 1
    • using in delete command 1
    • using in DELETE command 1
    • using in UPDATE command 1
  • database links
    • creating a synonym 1
  • data definition language 1
  • data definition language (DDL)
    • description 1
  • data integrity 1
  • data manipulation language (DML) 1
  • data type
    • host-languages 1
    • internal versus external 1
    • user defined 1
  • data type conversion
    • between internal and external datatypes 1
  • data type equivalencing
    • advantages 1
    • example 1
    • guidelines 1
  • Date data type
    • converting 1
    • default format 1
    • default value 1
    • external 1
    • internal 1
    • internal format 1
  • DB2_ARRAY precompiler option 1
  • DBMS option 1
  • deadlock
    • breaking 1
  • DECIMAL data type 1
  • declarartion
    • host array 1
    • host variable 1
  • declaration
    • cursor 1
    • indicator variable 1
    • of ORACA 1
    • SQLCA 1
  • declarative SQL statements
    • using in transactions 1
  • Declarative SQL statements 1
  • declare CURSOR command
    • examples 1
  • declare CURSOR statement 1
  • declare DATABASE directive 1
  • declare section
    • example 1
    • using more than one 1
  • DECLARE statement
    • example 1
    • where to place 1
  • declare STATEMENT command
    • example 1
    • scope of 1
  • DECLARE STATEMENT statement
    • AT clause 1
    • example 1
    • using in dynamic SQL 1
    • when required 1
  • DECLARE TABLE command
    • example 1
  • declare TABLE statement
    • need for with AT clause 1
  • DECLARE TABLE statement
    • need for with AT clause 1
    • using with the SQL CHECK option 1
  • DEF_SQLCODE precompiler option 1
  • default, setting of LITDELIM option 1
  • default connection 1
  • default database 1
  • DEFINE option 1
  • definition 1
  • delete cascaade 1
  • DELETE command
    • embedded SQL examples 1
  • DELETE statement
    • using SQLERRD(3) filed 1
    • WHERE clause 1
  • DESCRIBE command
    • example 1
  • DESCRIBE statement, using in dynamic SQL Method 4 1
  • directory
    • current 1
    • path for INCLUDE files 1
  • DISPLAY data type 1
  • distributed procesing 1
  • DO action 1
  • DO option, of WHENEVER command 1
  • DTP model 1
  • dummy host variables 1
  • DURATION precompiler option 1
  • dynamic PL/SQL 1
  • dynamic SQL
    • advantages and disadvantages 1
    • choosing the right method 1
    • guidelines 1
    • overview 1
    • using PL/SQL 1
    • when useful 1
  • dynamic SQL Method1
    • using EXECUTE IMMEDIATE 1
    • using PL/SQL 1
  • dynamic SQL Method 1
    • command 1
    • dexcription 1
    • example 1
    • requirements 1
  • dynamic SQL method 2
    • using the DECLARE STATEMENT Statement 1
  • dynamic SQL Method 2
    • commands 1
    • description 1
    • example 1
    • requirements 1
    • using PL/SQL 1
  • dynamic SQL method 3
    • using the DECLARE STATEMENT Statement 1
  • dynamic SQL Method 3
    • compared to method 2 1
    • description 1
    • example 1
    • requirements 1
    • using PL/SQL 1
    • using the CLOSE statement 1
    • using the OPEN statement 1
    • using the PREPARE statement 1
  • dynamic SQL Method4
    • using PL/SQL 1
  • dynamic SQL method 4
    • using the DECLARE STATEMENT Statement 1
  • dynamic SQL Method 4
    • overview 1
    • using descriptors 1
    • using SQLDA 1
    • using the DESCRIBE statement 1
    • when needed 1
  • dynamic SQL statement
    • binding of host variables 1
    • how processed 1
    • requirements 1
    • using host arrays 1
    • using placeholders 1

E

  • embedded PL/SQL
    • advantages 1
    • cursor for loops 1
    • example 1 , 2
    • need for SQL check option 1
    • packages 1
    • PL/SQL table 1
    • requirements 1
    • subprograms 1
    • user-defines record 1
    • using %TYPE 1
    • where allowed 1
  • embedded SQL
    • ALLOCATE command 1
    • CLOSE command 1
    • COMMIT command 1
    • CONNECTcommand 1
    • DECLARE CURSORcommand 1
    • DECLARE cursor command 1
    • DECLARE DATABASE command 1
    • DECLARE STATEMENT command 1
    • DECLARE TABLE command 1
    • DELETE command 1
    • DESCRIBE command 1
    • EXECUTEcommand 1
    • EXECUTE command 1
    • EXECUTE IMMEDIATE command 1
    • FETCH command 1
    • INSERT command 1
    • mixing with host-language statement 1
    • OPEN command 1 , 2
    • referencing indicator variables 1
    • SAVEPOINT command 1
    • SELECT command 1
    • UPDATE command 1
    • VAR command 1
    • versus interactive SQL 1
    • WHENEVER command 1
  • embedded SQL statement
    • referencing host-langauage varaibles 1
    • syntax 1
  • embedding PL/SQL blocks in Oracle 7 precompiler programs 1
  • EMP table 1
  • encoding scheme 1
  • equivalencing, data type 1
  • error detection, error reporting 1
  • error handling
    • alternatives 1
    • benefits 1
    • error handling
      • using the SQLCODE status variable 1
    • overview 1
    • SQLCA versus WHENEVER statement 1
    • SQLCODE status variable 1
    • using SQLCA 1
    • using the ORACA structure 1
    • using the ROLLBACK statement 1
    • using the SQLGLM function 1 , 2
    • using the WHENEVER statement 1
  • error message
    • available in SQLCA 1
    • maximum length 1
    • using in error reporting 1
    • using the SQLGLM function 1
  • error reporting
    • key components 1
    • using error messages 1
    • using status codes 1
    • using the parse error offset 1
    • using the rows-processed count 1
    • using warning flags 1
  • errors options 1
  • ERRTYPE
    • precompiler option 1
  • exception, PL/SQL 1
  • EXEC ORACLE DEFINE statement 1
  • EXEC ORACLE ELSE statement 1
  • EXEC ORACLE ENDIF statement 1
  • EXEC ORACLE IFDEF statement 1
  • EXEC ORACLE IFNDEF statement 1
  • EXEC ORACLE statement
    • inline 1
    • scope of 1
    • syntax for 1
  • EXEC SQL clause 1
  • EXEC TOOLS statements
    • GET 1
    • MESSAGE 1
    • SET 1
    • SET CONTEXT 1
  • executable SQL statement
    • example 1
  • EXECUTE IMMEDIATE command
    • example 1
  • EXECUTE IMMEDIATE statement
    • AT clause 1
  • EXECUTE statement, using in dynamic SQL Method 2 1
  • explicit logon
    • multiple 1
    • single 1
  • external datatype
    • CHAR 1
    • CHARF 1
    • CHARZ 1
    • DATE 1
    • DECIMAL 1
    • DISPLAY 1
    • FLOAT 1
    • INTEGER 1 , 2
    • LONG 1
    • LONG VARCHAR 1
    • LONG VARRAW 1
    • MLSLABEL 1
    • NUMBER 1
    • RAW 1
    • ROWID 1
    • STRING 1
    • UNSIGNED 1
    • VARCHAR 1
    • VARCHAR2 1
    • VARNUM 1

F

  • features, new 1
  • fetch, batch 1
  • FETCH command
    • examples 1
    • used after OPEN command 1
  • fetching, rows from cursors 1
  • FETCH statement
    • example 1
    • using the SQERRD(3) 1
  • FIPS option 1
  • flag, warning 1
  • FLOAT datatypes 1
  • FORCE clause
    • of COMMIT command 1
  • FOR clause
    • example 1
    • restrictions 1
    • using with HOST arrays 1
  • FORMAT option 1
  • forward reference 1
  • full scan 1
  • function prototype
    • definition of 1

G

  • GENXTB form, running 1
  • globalizaton support
    • multibyte charecter strings 1
  • globalizaton support parameter
    • currency 1
    • DATE FORMAT 1
    • DATE LANGUAGE 1
    • ISO CURRENCY 1
    • LANGUAGE 1
    • NUMERIC CHARACTERS 1
    • SORT 1
    • TERRITORY 1
  • GOTO action 1
  • GOTO optio, of WHENEVER command 1
  • guidelines
    • datatype equivalencing 1
    • dynamic SQL 1
    • host variable 1
    • separate precompilation 1
    • transactions 1
    • user exit 1
    • WHENEVER statement 1
  • guielines
    • indicator variables 1

H

  • HEADER precompiler option 1
  • heap 1
  • hint, optimizer 1
  • hints
    • in DELETE statements 1
    • in SELECTstatement 1
    • in UPDATEstatement 1
  • HOLD_CURSOR precompiler option 1
  • HOLD CURSOR option
    • of Oracle precompilers 1
  • host array
    • advantages 1
    • declaring 1
    • dimensions 1
    • maximum size 1
    • referencing 1
    • restrictions 1 , 2 , 3
    • using dynamic SQL statement 1
    • using in the DELETE statement 1
    • using in the INSERT statement 1
    • using in the SELECTstatement 1
    • using in the UPDATE statement 1
    • using in the WHERE clause 1
    • using to improve performance 1
    • when not allowed 1
  • host language 1
  • host-language datatype 1
  • host option 1
  • host program 1
  • host varaible
    • in OPEN command 1
    • multi-byte charecter strings 1
    • undeclare 1
    • using in EXEC TOOLS statement 1
    • using in PL/SQL 1
  • host variable
    • assigning a value 1
    • declaring 1
    • dummy 1
    • host variable equivalencing 1
    • in EXECUTE command 1
    • in OPEN command 1
    • output versus input 1
    • overview 1
  • host variables
    • using in user exit 1
    • where allowed 1

I

  • IAF GET statement
    • example 1
    • specifying block and field names 1
    • using user exit 1
  • IAF PUT statement
    • example 1
    • specifying block and filed names 1
    • using user exit 1
  • IAP 1
  • IMPLICIT_SVPT precompiler option 1
  • implicit logon 1
  • implicit logons
    • multiple 1
    • single 1
  • INAME option
    • when a file extension is required 1
  • INCLUDE file 1
  • INCLUDE option 1
  • INCLUDE statement
    • using to declare the SQLCA 1
  • index, using to improve performance 1
  • indiacator array 1
  • indicator varaible 1
  • indicator variable
    • guidelines 1
    • referencing 1
  • indicator variables
    • used to detetc truncated values 1
    • used with multi-byte charecter strings 1
    • using in PL/SQL 1
    • using to handle nulls 1 , 2
    • using to test for nulls 1
  • in doubt transaction 1
  • IN OUT parameter modes 1
  • input host variable
    • restrictions 1
    • where allowed 1
  • INSERT command
    • embedded SQL examples 1
  • inserting, rows into tables and views 1
  • INSERT of no rows
    • cause of 1
  • INSERT statement
    • column list 1
    • example 1
    • INTO clause 1
  • interface
    • native 1
    • XA 1
  • internal datatypes
    • CHAR 1
    • DATE 1
    • definition 1
    • LONG 1
    • LONG RAW 1
    • MLSLABEL 1
    • NUMBER 1
    • RAW 1
    • ROWID 1
    • VARCHAR2 1
  • INTO clause
    • INSERT statement 1
    • of FETCH command 1
    • of SELECT statement 1
  • INTYPE precompiler option 1
  • IRECLEN option 1

J

  • julian date 1

K

  • keywords 1

L

  • language support 1
  • LDA 1
  • LEVEL pseudocolumn 1
  • LINES precompiler option 1
  • link, database 1
  • linking 1
  • LITDELIM option
    • purpose 1
  • LNAME option 1
  • location transparency 1
  • lock, released by ROLLBACK statement 1
  • locking
    • explicit versus implicit 1
    • modes 1
    • privileges needed 1
    • using the FOR UPDATE of clause 1
    • using the LOCK TABLE statement 1
  • LOCK TABLE statement
    • example 1
    • using the NOWAIT parameter 1
  • logon
    • concurrent 1
    • explicit 1
  • Logon Data Area (LDA) 1
  • LONG datatype
    • comapred with CHAR 1
    • external 1
    • internal 1
    • restriction 1
  • LONG RAW column, maximum width 1
  • LONG RAW datatype
    • compared with LONG 1
    • conversion 1
    • external 1
    • internal 1
  • LONG VAR CHAR datatype 1
  • LONG VARRAW datatype 1
  • LRECLEN option 1
  • LTYPE option 1

M

  • MAX_ROW_INSERT precompiler option 1
  • MAXLITERAL option 1
  • MAXOPENCURSORS option
    • using for separate precompilation 1
    • what it affects 1
  • MLSLABEL data type 1
  • mode, parameter 1
  • MODE option 1
  • monitor, transaction processing 1
  • multi-byte character sets 1
  • MULTISUBPROG option 1

N

  • namespaces, reserved by Oracle 1
  • naming conventions
    • cursor 1
    • SQL* Forms user exit 1
  • naming of database objects 1
  • NATIVE
    • value of DBMS option 1
  • NATIVE_TYPES precompiler option 1
  • native interface 1
  • network
    • communicating over 1
    • protocol 1
    • reducing network traffic 1
  • NEXTVAL, psuedocolumn 1
  • nibble 1
  • NIST, compliance 1
  • NLS_CHAR precompiler option 1
  • NLS_LOCAL precompiler option 1
  • node, definition 1
  • notation
    • convention 1
  • NOWAIT
    • parameter 1
    • using the LOCK TABLE statement 1
  • null
    • definition 1
    • detecting 1
    • hardcode 1
    • inserting 1
    • restrictions 1
    • retrieving 1
    • testing for 1
  • null-terminated string 1
  • NUMBER data type
    • external 1
    • internal 1

O

  • OBJECTS precompiler option 1 , 2
  • OCI
    • declaring LDA 1
    • embedding calls 1
  • ONAME option 1
  • OPEN command
    • examples 1
  • OPEN-FOR statement 1
  • opening, cursors 1
  • OPEN statement
    • example 1
    • using in dynamic SQL Method 3 1
  • optimizer hint 1
  • options, precompiler 1
  • ORACA
    • declaring 1
    • enabling 1
    • example 1
    • fields 1
    • gathering cursor cache statistics 1
    • ORACABC field 1
    • ORACAID field 1
    • ORACCHF flag 1
    • ORACOC field 1
    • ORADBGF flag 1
    • ORAHCHF flag 1
    • ORAHOC field 1
    • ORAMOC field 1
    • ORANEX field 1
    • ORANOR field 1
    • ORANPR field 1
    • ORASFNMC field 1
    • ORASFNML field 1
    • ORASLNR field 1
    • ORASTXTC field 1
    • ORASTXTF flag 1
    • ORASTXTL field 1
    • using more than one 1
  • ORACABC field 1
  • ORACAID field 1
  • ORACA option 1
  • ORACCHF flag 1
  • Oracle Call Interface 1
  • Oracle Communications Area 1
  • Oracle datatypes 1
  • Oracle Forms, using the EXEC TOOLS statements 1
  • Oracle identifier, how to form 1
  • Oracle indentifiers, how to form 1
  • Oracle keywords 1
  • Oracle namespaces 1
  • Oracle Precompilers
    • advantages 1
    • function 1
    • globalization support 1
    • language support 1
    • new features 1
    • running 1
    • using PL/SQL 1
    • using with OCI 1
  • Oracle reserved words 1
  • Oracle Toolset 1
  • ORACOC field 1
  • ORADBGF flag 1
  • ORAHCHF flag 1
  • ORAHOC field 1
  • ORAMOC field 1
  • ORANEX field 1
  • ORANOR field 1
  • ORANPR field 1
  • ORASFNMC field 1
  • ORASFNML field 1
  • ORASLNR field 1
  • ORASTXTC field 1
  • ORASTXTF flag 1
  • ORASTXTL field 1
  • ORECLEN option 1
  • OUTLINE precompiler option 1
  • OUTLNPREFIX precompiler option 1
  • output host variable 1

P

  • PAGELEN option 1
  • parameter modes 1
  • parent cursor 1
  • parse 1
  • PARSE
    • precompiler option 1
  • parse error offset 1
  • parsing dynamic statements, PREPARE command 1
  • performance
    • improving 1
    • reasons for poor 1
  • PL/SQL
    • advantages 1
    • and the SQLCA 1
    • blocks, embedded in Oracle precompiler programs 1
    • cursor FOR loop 1
    • exception 1
    • integrating with server 1
    • package 1
    • relationship with SQL 1
    • reserved words 1
    • subprogram 1
    • user-defined record 1
  • PL/SQL table 1
  • placeholder, duplicate
    • naming 1
    • using in dynamic SQL statements 1
  • plan, execution 1
  • precision 1
  • precompilation
    • conditional 1
    • separate 1
  • precompilation unit 1
  • precompiler 1
  • precompiler command
    • optional arguments of 1
    • required arguments 1
  • precompiler directives, EXEC SQL DECLARE DATABASE 1
  • precompiler options
    • abbrevating name 1
    • ASACC 1
    • ASSUME_SQLCODE 1
    • AUTO_CONNECT 1
    • CHAR_MAP 1
    • CINCR 1
    • CLOSE_ON_COMMIT 1
    • CMAX 1
    • CMIN 1
    • CNOWAIT 1
    • CODE 1
    • COMMON_NAME 1
    • COMMON_PARSER 1
    • COMP_CHARSET 1
    • CONFIG 1 , 2
    • CPOOL 1
    • CPP_SUFFIX 1
    • CTIMEOUT 1
    • DB2_ARRAY 1
    • DBMS 1
    • DEF_SQLCODE 1
    • DEFINE 1
    • displaying 1 , 2
    • DURATION 1
    • entering from a configuration file 1
    • entering inline 1
    • entering on the command line 1
    • ERRORS 1
    • ERRTYPE 1
    • FIPS 1
    • FORMAT 1
    • Globalization Support_LOCAL 1
    • HEADER 1
    • HOLD_CURSOR 1
    • HOST 1
    • IMPLICIT_SVPT 1
    • INAME 1
    • INCLUDE 1
    • INTYPE 1
    • IRECLEN 1
    • LINES 1
    • LITDELIM 1
    • LNAME 1
    • LRECLEN 1
    • LTYPE 1
    • MAX_ROW_INSERT 1
    • MAXLITERAL 1
    • MAXOPENCURSORS 1
    • MODE 1
    • MULTISUBPROG 1
    • NATIVE_TYPES 1
    • NLS_CHAR 1
    • NLS_LOCAL 1
    • OBJECTS 1 , 2
    • ONAME 1
    • ORACA 1
    • ORECLEN 1
    • OUTLINE 1
    • OUTLNPREFIX 1
    • PAGELEN 1
    • PARSE 1
    • PREFETCH 1
    • RELEASE_CURSOR 1
    • respecifying 1
    • RUNOUTLINE 1
    • scope of 1
    • SELECT_ERROR 1
    • specifying 1
    • SQLCHECK 1 , 2
    • STMT_CACHE 1
    • syntax for 1
    • THREADS 1
    • TYPE_CODE 1
    • UNSAFE_NULL 1
    • USERID 1
    • using 1
    • VARCHAR 1
    • VERSION 1
    • XREF 1
  • PREFETCH precompiler option 1
  • PREPARE command
    • examples 1
  • PREPARE statement
    • using in dynamic SQL 1 , 2
  • private SQL area
    • association with cursors 1
    • opening 1
    • purpose 1
  • Program Global Area (PGA) 1
  • programming language support 1
  • program termination 1
  • pseudocolumn
    • CURRVAL 1
    • LEVEL 1
    • NEXTVAL 1
    • ROWID 1
    • ROWNUM 1
    • SYSDATE 1
    • UID 1
    • USER 1
  • pseudotype, VARCHAR 1

Q

  • query
    • association with cursor 1
    • multirow 1
    • single-row versus multirow 1

R

  • RAW column, maximum width 1
  • RAW datatype
    • compared with CHAR 1
    • converting 1
    • external 1
    • internal 1
    • restrictions 1
  • read consistency 1
  • READ ONLY parameter, using in SET TRANSACTION 1
  • read-only transaction
    • ending 1
    • example 1
  • record, user-defined 1
  • reference
    • host array 1
    • host variable 1
    • indicator variable 1
  • RELEASE_CURSOR option
    • of Oracle Precompilers 1
    • using to improve performance 1
  • RELEASE option
    • COMMIT statement 1
    • omitting 1
    • restrictions 1
    • ROLLBACK statement 1
  • remote database, declaration of 1
  • reserved words
    • PL/SQL 1
  • resource manager 1
  • retrieving rows from a table, embedded SQL 1
  • return code 1
  • rollabck
    • statement-level 1
  • rollback
    • automatic 1
    • purpose 1
  • roll back
    • to a savepoint 1
    • to the same savepoint multiple times 1
  • ROLLBACK command
    • ending a transaction 1
    • examples 1
  • rollback segment 1
  • ROLLBACK statement
    • effects 1
    • example 1
    • RELEASE option 1
    • TO SAVEPOINT clause 1
    • using in a PL/SQL block 1
    • using in error-handling routines 1
    • where to place 1
  • ROLLBACK Statement 1
  • rolling back, transactions 1
  • ROWID datatype
    • external 1
    • internal 1
  • ROWID pseudocolumn
    • using to mimic CURRENT OF 1 , 2
  • ROWLABEL column 1
  • row lock
    • acquiring with FOR UPDATE OF 1
    • using to improve performance 1
    • when acquired 1
    • when released 1
  • ROWNUM pseudocolumn 1
  • rows
    • fetching from cursors 1
    • inserting into tables and views 1
    • updating 1
  • rows-processed count
    • using in error reporting 1
  • RUNOUTLINE precompiler option 1

S

  • sample database table
    • DEPT table 1
    • EMP table 1
  • savepoint 1
  • savepoint, when erased 1
  • SAVEPOINT command
    • example 1
  • savepoints, creating 1
  • SAVEPOINTS parameter 1
  • SAVEPOINT statement
    • example 1
  • scale
    • definition of 1
    • when negative 1
  • scope
    • of DECLARE STATEMENT command 1
    • of precompiler options 1
    • of the EXEC ORACLE statement 1
    • WHENEVER statement 1
  • search condition
    • using in the WHERE clause 1
  • SELECT_ERROR option 1
  • SELECT command
    • embedded SQL examples 1
  • select descriptor, information in 1
  • select list 1
  • SELECT statement
    • available clauses 1
    • example 1
    • INTO clause 1
    • using host arrays 1
    • using the SQLERRD(3) field 1
  • semantic checking
    • enabling 1
    • using the SQLCHECK option 1
  • separate precompilation
    • guidelines 1
    • restrictions 1
  • session 1
  • sessions, beginning 1
  • SET clause
    • using a subquery 1
  • SET TRANSACTION statement
    • example 1
    • READ ONLY parameter 1
    • restrictions 1
  • snapshots 1
  • SQL_CURSOR 1
  • SQL, summary of commands 1
  • SQL*Connect, using ROWID datatype 1
  • SQL*Forms
    • Display Error screen 1
    • IAP Constants 1
    • returning values to 1
    • Reverse Return Code switch 1
    • user exit 1
  • SQL*Net
    • concurrent logons 1
    • connection syntax 1
    • function of 1
    • using to connect to Oracle 1
  • SQL*Plus 1
  • SQL92
    • conformance 1
    • deprecated feature 1
    • minimum requirement 1
  • SQLCA
    • components set for a PL/SQL block 1
    • declaring 1
    • explicit versus implicit checking 1
    • fields 1
    • interaction with Oracle 1
    • using in separate precompilations 1
    • using more than one 1
    • using with SQL*Net 1
  • SQLCABC filed 1
  • SQLCAID field 1
  • SQLCHECK option
    • restrictions 1
    • usage notes for 1
    • using the DECLARE TABLE statement 1
    • using to check syntax 1
  • SQLCHECK precompiler option 1
  • SQL code, returned by SQLGLS function 1
  • SQLCODE field 1
  • SQLCODE status variable 1
  • SQLCODE variable, interpreting values of 1
  • SQL Communications Area 1
  • SQL Descriptor Area 1
  • SQLERRD 1
  • SQLERRD(3) field
    • purpose 1
    • using with the FETCH statement 1
  • SQLERRD(3) filed
    • using with batch fetch 1
  • SQLERRD(5) field 1
  • SQLERRMC field 1
  • SQLERRML field 1
  • SQLERROR condition 1
  • SQLFC parameter 1
  • SQLGLM function
    • example 1
  • SQLGLS function
    • parameters 1
    • restrictions 1
    • SQL codes returned by 1
    • syntax 1
    • using to obtain SQL text 1
  • SQLIEM function
    • replacement for 1
    • using in user exit 1
  • SQLLDA routine 1
  • SQL standards conformance 1
  • SQL statement
    • controlling transactions 1
    • executable versus declarative 1
    • optimizing to improve performance 1
    • static versus dynamic 1
    • using to control a cursor 1 , 2
    • using to manipulate Oracle data 1
  • SQLSTATE status variable
    • class code 1
    • coding scheme 1
    • declaring 1
    • error handling
      • SQLSTATE status variable 1
    • interpreting values 1
    • predefined status code and conditions 1
    • subclass code 1
  • SQLSTM parameter 1
  • SQLWARN 1
  • SQLWARN flags 1
  • SQLWARNING condition 1
  • statement-level rollback
    • breaking deadlocks 1
  • status code 1
  • STMLEN parameter 1
  • STMT_CACHE
    • precompiler option 1
  • STOP action 1
  • stored subprogram
    • calling 1
    • creating 1
    • packaged versus standalone 1
    • stored versus inline 1
    • using to improve performance 1
  • STRING datatype 1
  • subprogram, PL/SQL 1 , 2
  • subquery
    • example 1 , 2
    • using in the SET clause 1
    • using in the VALUES clause 1
  • syntactic checking 1
  • syntax, embedded SQL 1
  • syntax diagram
    • description of 1
    • how to read 1
    • how to use 1
    • symbols used in 1
  • SYSDATE function 1
  • system failure, effect on transactions 1
  • System Global Area (SGA) 1

T

  • table lock
    • acquiring with LOCK TABLE 1
    • exclusive 1
    • row share 1
    • when released 1
  • tables
    • inserting rows into 1
    • updating rows in 1
  • THREADS
    • precompiler option 1
  • TO SAVEPOINT clause
    • restrictions 1
    • using in ROLLBACK statement 1
  • trace facility, using to improve performance 1
  • transaction
    • subdividing with savepoints 1
    • undoing 1
    • undoing parts of 1
    • when rolled back automatically 1 , 2
  • transaction, contents
    • guidelines 1
    • how to begin 1
    • how to end 1
    • in-doubt 1
    • making permanent 1
  • transaction, read-only 1
  • transaction processing
    • overview 1
    • statements used 1
  • transactions
    • committing 1
    • distributed 1
    • rolling back 1
  • truncated value
    • detecting 1
  • truncation error, when generated 1
  • tuning, performance 1
  • TYPE_CODE
    • precompiler option 1
  • TYPE statement, using the CHARF datatype specifier 1

U

  • UID function 1
  • unconditional delete 1
  • undo a transaction 1
  • UNSAFE_NULL option 1 , 2
  • UNSIGNED datatype 1
  • update cascade 1
  • UPDATE command
    • embedded SQL examples 1
  • UPDATE statement
    • example 1
    • SET clause 1
    • using host arrays 1
    • using SQLERRD(3) 1
  • updating, rows in tables and views 1
  • user-defined datatype 1
  • user-defined record 1
  • user exit
    • calling from a SQL*Forms trigger 1
    • common uses 1
    • example 1
    • guidelines 1
    • linking into IAP 1
    • meaning of codes returned by 1
    • naming 1
    • passing parameters 1
    • requirements for variables 1
    • running the GENXTB form 1
    • statements allowed in 1
    • steps in developing 1
    • using EXEC IAF statements 1
    • using EXEC TOOLS statements 1
    • using the WHENEVER statement 1
  • USER function 1
  • USERID option
    • using with the SQLCHECK option 1
  • user session 1
  • USING clause
    • CONNECT statement 1
    • using indicator variables 1
    • using in the EXECUTE statement 1
  • using dbstring, SQL*Net database id specification 1

V

  • V7
    • value of DBMS option 1
  • VALUES clause
    • INSERT statement 1
    • using a subquery 1
  • VARCHAR, precompiler option 1
  • VARCHAR2 column
    • maximum width 1
  • VARCHAR2 datatype
    • external 1
    • internal 1
  • VARCHAR datatype 1
  • VARCHAR pseudotype
    • maximum length 1
    • using with PL/SQL 1
  • VAR command
    • examples 1
  • variable 1
  • VARNUM datatype
    • example of output value 1
  • VARRAW 1
  • VARRAW datatype 1
  • VAR statement
    • parameters 1
    • using the CHARF datatype specifier 1
  • VERSION precompiler option 1
  • views
    • inserting rows into 1
    • updating rows in 1

W

  • warning flag 1
  • when empty 1
  • WHENEVER command
    • example 1
  • WHENEVER statement
    • check SQLCA automatically 1
    • CONTINUE action 1
    • DO action 1
    • examples 1
    • GOTO action 1
    • guidelines 1
    • handling end-of-data conditions 1
    • maintaining addressability 1
    • NOT FOUND condition 1
    • overview 1
    • scope 1
    • SQLERROR condition 1
    • SQLWARNING condition 1
    • STOP action 1
    • where to place 1
  • WHERE clause
    • search condition 1
    • SELECT statement 1
    • UPDATE statement 1
    • using host arrays 1
  • WHERE Clause
    • DELETE statement 1
  • WORK option
    • of COMMIT command 1

X

  • X/Open application 1
  • XA interface 1
  • XREF option 1