Index
A
- abbreviations permitted 2.2.1
- abnormal termination
- automatic rollback E.8
- active set 5.4
- ALLOCATE DESCRIPTOR statement E.5
- ALLOCATE statement E.4
- use with ROWID 4.7
- allocating
- allocating cursor variables 6.10.2
- ALTER AUTHORIZATION
- changing password 3.2.4
- ANSI/ISO SQL
- extensions 14.7.18
- ANSI dynamic SQL F.2.3
- See also dynamic SQL (ANSI) 10
- ANSI format
- COBOL statements 2.2.4
- application development process 2.1.1
- ARRAYLEN statement 6.6.1
- ASACC precompiler option 14.7.1
- ASSUME_SQLCODE precompiler option 14.7.2
- AT clause
- CONNECT statement 3.2.2.1
- DECLARE CURSOR statement 3.2.2.1
- DECLARE STATEMENT statement 3.2.2.1
- EXECUTE IMMEDIATE statement 3.2.2.1
- of COMMIT statement E.8
- of CONNECT statement E.9
- of DECLARE CURSOR directive E.14
- of DECLARE STATEMENT directive E.16
- of EXECUTE IMMEDIATE statement E.25
- of EXECUTE statement E.22
- of INSERT statements E.30
- of SAVEPOINT statement E.53
- of SELECT statement E.54
- of UPDATE statement E.56
- restrictions 3.2.2.1
- AUTO_CONNECT option
- instead of CONNECT statement 3.2.3.1
- AUTO_CONNECT precompiler option 14.7.3
- automatic logons 3.2.3
- Avoiding Unnecessary Reparsing C.10
B
- batch fetch 7.4.1
- BFILES
- definition 13.1.2
- bind descriptor 11.2.1
- bind descriptors
- information in 9.13.2
- binding host variables 9.5
- bind SQLDA 11.1.3
- bind variables 9.13.1
- BNDDFCLP variable (SQLDA) 11.3
- BNDDFCRCP variable (SQLDA) 11.3
- BNDDFMT variable (SQLDA) 11.3
- BNDDH-CUR-VNAMEL variable (SQLDA) 11.3
- BNDDH-MAX-VNAMEL variable (SQLDA) 11.3
- BNDDH-VNAME variable (SQLDA) 11.3
- BNDDI-CUR-VNAMEL variable (SQLDA) 11.3
- BNDDI-MAX-VNAMEL variable (SQLDA) 11.3
- BNDDI variable (SQLDA) 11.3
- BNDDI-VNAME variable (SQLDA) 11.3
- BNDDVLN variable (SQLDA) 11.3
- BNDDVTYP variable (SQLDA) 11.3
- BNDDV variable (SQLDA) 11.3
C
- CALL SQL statement 6.8.2.2
- CALL statement E.6
- example 6.8.2.3
- case-insensitivity 2.2.2
- character host variables
- character sets
- multibyte 4.9
- character strings
- multibyte 4.9.2
- CHAR datatypes
- external 4.1.2.1
- CHARF datatypes
- external 4.1.2.2
- CHARF datatype specifier 4.12.3
- using in VAR statement 4.12.3
- CHARZ datatype
- external 4.1.2.3
- CLOSE_ON_COMMIT
- CLOSE_ON_COMMIT precompiler option 14.7.6
- CLOSE command
- examples E.7
- CLOSE statement E.7
- closing
- cursors E.7
- COBOL-74 A.1.1
- COBOL-85 A.1.1
- COBOL versions supported 2.2.3, A.1.1
- code page 4.8
- coding area
- for paragraph names 2.2.22
- coding conventions 2.2
- column list 5.3.3
- COMMENT clause
- of COMMIT statement E.8
- comments
- comments in dynamic PL/SQL blocks 9.16.5
- commit 3.4
- COMMIT statement 3.6, E.8
- committing
- transactions E.8
- COMP_CHARSET precompiler option 14.7.7
- compilation 2.7
- composite types 11.4.3
- concurrency 3.3
- concurrent logons 3.2.1
- conditional precompilation 2.5
- CONFIG precompiler option 14.7.6, 14.7.8
- configuration file
- system versus user 14.7.8
- connecting to Oracle 3.1
- connections
- CONNECT statement E.9
- CONTEXT ALLOCATE statement 12.4.2.3, E.10
- CONTEXT FREE statement 12.4.2.5, E.11
- CONTEXT USE directive 12.4.2.4
- CONTEXT USE SQL directive E.12
- CONTEXT USE SQL statement 12.4.2.4
- continuation lines
- syntax 2.2.7
- CONTINUE action
- CONVBUFSZ clause in VAR statement 4.12.2.1
- CREATE PROCEDURE statement 6.8.1
- creating
- savepoints E.53
- CURRENT OF clause 5.4.5, 7.3.5
- current row 5.4
- CURRVAL pseudocolumn 4.1.2.23
- cursor cache 8.4.4
- cursors 5.4
- allocating E.4
- association with query 5.4
- closing E.7
- declaring 5.4.1
- effects on performance C.9.1
- explicit versus implicit 5.4
- fetching rows from E.26, E.27
- naming 5.4.1
- opening E.49, E.50
- reopening 5.4.2, 5.4.3
- restricted scope of 2.6.2
- restrictions 5.4.1
- scope 5.4.1
- using for multirow queries 5.4
- using more than one 5.4.1
- when closed automatically 5.4.4
- cursor variables 6.10, E.4
D
- database links
- data definition language (DDL)
- data integrity 3.3
- data lock 3.3
- datatype
- internal versus external 2.1.7
- datatype conversion
- between internal and external types 4.11
- datatype equivalencing
- datatypes
- ANSI DATE 4.2
- coercing NUMBER to VARCHAR2 11.4.3
- conversions 4.10
- dealing with Oracle internal 11.4.3
- descriptor codes 11.4.3
- equivalencing
- internal 11.4.2
- INTERVAL DAY TO SECOND 4.2
- INTERVAL YEAR TO MONTH 4.2
- need to coerce 11.4.3
- PL/SQL equivalents 11.4.3
- TIMESTAMP 4.2
- TIMESTAMP WITH LOCAL TIME ZONE 4.2
- TIMESTAMP WITH TIME ZONE 4.2
- when to reset 11.4.3
- DATE_FORMAT precompiler option 14.7.9
- DATE, ANSI
- datatype 4.2
- DATE datatype
- DATE String Format
- explicit control over 4.11
- DBMS precompiler option 14.7.10, 14.7.11
- DDL 14.7.35
- DDL (Data Definition Language) 5.1.1
- deadlock 3.3
- DEALLOCATE DESCRIPTOR statement E.13
- DECIMAL datatype 4.1.2.5
- declaration
- declarative SQL statement 2.1.2.1
- using in transactions 3.5
- declarative statements
- also known as directives 2.1.2.1
- DECLARE_SECTION precompiler option 14.7.12
- DECLARE CURSOR directive E.14
- DECLARE CURSOR statement
- DECLARE DATABASE directive E.15
- declare section
- defining usernames and passwords 3.1
- Declare Section
- DECLARE statement
- using in dynamic SQL method 3 9.11.2
- DECLARE STATEMENT directive E.16
- DECLARE STATEMENT statement
- DECLARE TABLE directive E.17
- examples E.17
- DECLARE TABLE directives
- using with the SQLCHECK option D.3.1.2
- declaring
- default
- default connection 3.2.1
- DEFINE precompiler option 14.7.13
- DELETE statement E.18
- DEPENDING ON clause 7.3.1.1
- DEPT table 2.8
- DESCRIBE BIND VARIABLES statement
- in dynamic SQL method 4 11.6.8
- DESCRIBE DESCRIPTOR statement E.20
- DESCRIBE SELECT LIST statement
- in dynamic SQL method 4 11.6.12
- DESCRIBE statement E.19
- descriptor
- naming E.19
- descriptors
- dimension of host tables 7.3.1.1
- directives
- also known as declarative statements 2.1.2.1
- directory path
- INCLUDE files 2.3.3.2
- DISPLAY datatype 4.1.2.6
- distributed processing 3.2.1
- DML returning clause 5.3.3
- DO CALL action
- DO PERFORM action
- DSNTIAR
- DB2 compatible feature 8.3.7
- DSNTIAR routine 8.3.7
- DYNAMIC option
- effect on functionality 10.5
- dynamic PL/SQL 9.16
- dynamic SQL
- dynamic SQL (ANSI) F.2.3
- ALLOCATE DESCRIPTOR statement 10.6.1
- basics 10.1
- bulk operations 10.4.2
- CLOSE CURSOR statement 10.6.13
- compared to Oracle dynamic SQL method 4 10
- DEALLOCATE DESCRIPTOR statement 10.6.2
- DESCRIBE DESCRIPTOR statement 10.6.6
- differences from Oracle dynamic SQL 10.6.14
- EXECUTE statement 10.6.8
- FETCH statement 10.6.12
- GET DESCRIPTOR statement 10.6.3
- OPEN statement 10.6.11
- Oracle extensions 10.4
- overview 10.2
- precompiler options 10.1.1, 10.5
- reference semantics 10.4.1
- restrictions 10.6.15
- SAMPLE12.PCO 10.7
- sample programs 10.7
- SET DESCRIPTOR statement 10.6.4
- use of DECLARE CURSOR 10.6.10
- use of EXECUTE IMMEDIATE statement 10.6.9
- use of PREPARE statement 10.6.5
- when to use 10
- dynamic SQL method 1
- dynamic SQL method 2
- dynamic SQL method 3
- dynamic SQL method 4
- CLOSE statement 11.6.17
- DECLARE CURSOR statement 11.6.7
- DESCRIBE statement 11.6.8, 11.6.12
- external datatypes 11.4.2
- FETCH statement 11.6.15
- internal datatypes 11.4.2
- OPEN statement 11.6.11
- PREPARE statement 11.6.6
- prerequisites 11.4
- purpose of descriptors 11.2.1
- requirements 9.6.4, 11.1.1
- sequence of statements used 11.6
- SQLDA 11.2
- steps for 11.5
- using descriptors 9.13
- using PL/SQL 9.16.4
- using the DECLARE STATEMENT statement 9.14
- using the DESCRIBE statement 9.13.1
- using the FOR clause 9.15
- using the SQLDA 9.13.1
- when needed 9.13
- dynamic SQL statement 9.1
E
- embedded DDL 14.7.35
- embedded PL/SQL
- advantages 6.2.1
- cursor FOR loop 6.2.3
- example 6.4.1, 6.4.2
- host variables 6.1.1
- indicator variables 6.1.3
- multibyte Globalization Support features 4.9.1
- need for SQLCHECK option 6.3
- need for USERID option 6.3
- overview
- support for SQL 2.1.5
- package 6.2.5
- PL/SQL table 6.2.6
- requirements 6.1
- subprogram 6.2.4
- user-defined record 6.2.7
- using %TYPE 6.2.2
- using the VARCHAR pseudotype 6.4.3
- using to improve performance C.4
- VARCHAR variables 6.1.2
- where allowed 6.1, 6.3
- embedded SQL
- ALLOCATE DESCRIPTOR statement E.5
- ALLOCATE statement 4.7, 6.10.2, E.4
- CALL statement 6.8.2.2, E.6
- CLOSE statement 5.4.4, 6.10.5, E.7
- COMMIT statement E.8
- CONNECT statement E.9
- CONTEXT ALLOCATE statement 12.4.2.3, E.10
- CONTEXT FREE statement 12.4.2.5, E.11
- CONTEXT USE directive E.12
- DEALLOCATE DESCRIPTOR statement E.13
- DECLARE [CURSOR] directive 5.4.1
- DECLARE CURSOR directive E.14
- DECLARE DATABASE directive E.15
- DECLARE STATEMENT directive E.16
- DECLARE TABLE directive E.17
- DELETE statement 5.3.6, E.18
- DESCRIBE DESCRIPTOR statement E.20
- DESCRIBE statement E.19
- ENABLE THREADS statement 12.4.2.2
- EXECUTE...END-EXEC statement E.22
- EXECUTE IMMEDIATE statement E.25
- EXECUTE statement E.23
- FETCH DESCRIPTOR statement E.27
- FETCH statement 5.4.3, 6.10.4, E.26, E.27
- FREE statement 6.10.6, E.28
- GET DESCRIPTOR statement E.29
- INSERT statement 5.3.2, 7.5, E.30
- key concepts 2.1
- OPEN DESCRIPTOR statement E.50
- OPEN statement 5.4.2, E.49, E.50
- PREPARE statement E.51
- ROLLBACK statement E.52
- SAVEPOINT statement 3.8, E.53
- SELECT statement 5.3.1, 7.4, E.54
- SET DESCRIPTOR statement E.55
- SET TRANSACTION statement 3.10
- UPDATE statement 5.3.5, E.56
- VAR directive E.57
- versus interactive SQL 2.1.3
- WHENEVER directive E.58
- when to use 1.4
- embedded SQL statements
- associating paragraph names with 2.2.22
- comments 2.2.6
- continuation 2.2.7
- figurative constants 2.2.13
- mixing with host-language statements 2.1.3
- referencing host tables 7.3.2
- referencing host variables 4.3.2
- referencing indicator variables 4.4.3
- requirements 2.2.12
- summary E.1
- syntax 2.1.3, 2.2.12
- terminator 2.2.25
- embedding
- PL/SQL blocks in Oracle7 precompiler programs E.22
- EMP table 2.8
- ENABLE THREADS SQL statement E.21
- ENABLE THREADS statement 12.4.2.2
- enabling
- threads 12.4.2.2
- encoding scheme 4.8
- END_OF_FETCH precompiler option 14.7.15
- equivalencing
- host variable equivalencing E.57
- equivalencing datatypes 4.12
- error detection
- error reporting E.58
- error handling
- error messages
- maximum length 8.3.6
- error message text
- SQLGLM subroutine 8.3.6
- error reporting
- ERRORS precompiler option 14.7.16
- exception, PL/SQL 6.5.1
- EXEC ORACLE DEFINE statement 2.5
- EXEC ORACLE ELSE statement 2.5
- EXEC ORACLE ENDIF statement 2.5
- EXEC ORACLE IFDEF statement 2.5
- EXEC ORACLE IFNDEF statement 2.5
- EXEC ORACLE statement
- EXEC SQL clause 2.1.3, 2.2.12
- EXECUTE...END-EXEC statement E.22
- EXECUTE IMMEDIATE statement E.25
- EXECUTE optional keyword of ARRAYLEN statement 6.6.1.1
- EXECUTE statement E.23
- execution plan C.5
- EXPLAIN PLAN statement
- using to improve performance C.5.1.1
- explicit logon
- single 3.2.2.1
- explicit logons 3.2.2
- external datatypes
- CHAR 4.1.2.1
- CHARF 4.1.2.2
- CHARZ 4.1.2.3
- DECIMAL 4.1.2.5
- definition 2.1.7
- DISPLAY 4.1.2.6
- dynamic SQL method 4 11.4.2
- FLOAT 4.1.2.7
- INTEGER 4.1.2.8
- LONG 4.1.2.9
- LONG RAW 4.1.2.10
- LONG VARCHAR 4.1.2.11
- LONG VARRAW 4.1.2.12
- parameters 4.12.2
- RAW 4.1.2.15
- STRING 4.1.2.17
- table of 4.1.2
- UNSIGNED 4.1.2.18
- VARCHAR 4.1.2.19
- VARCHAR2 4.1.2.20
- VARNUM 4.1.2.21
- VARRAW 4.1.2.22
F
- fetch, batch 7.4.1
- fetching
- FETCH SQL statement E.27
- FETCH statement 5.4.3, E.26
- figurative constants
- embedded SQL statements 2.2.13
- file extension
- for INCLUDE files 2.3.3.1
- file length limit 2.2.14
- FIPS flagger
- warns of array usage 7.3.6
- FIPS precompiler option 14.7.18
- flags 8.3.3.2
- FLOAT datatype 4.1.2.7
- FORCE clause
- FOR clause 7.9
- format mask 4.11
- FORMAT precompiler option 14.7.19
- purpose 2.2.4
- formats of COBOL statements
- FOR UPDATE OF clause 3.11.1
- forward reference 5.4.1
- freeing
- FREE statement E.28
- full scan C.7
G
H
- header files 1.7.1
- heap 8.4.4
- heap memory
- allocating cursor variables 6.10.2
- heap tables 4.7
- hint, optimizer C.5.1
- hints
- HOLD_CURSOR option
- HOLD_CURSOR precompiler option 14.7.20
- host language 2.1.2
- HOST precompiler option 14.7.21
- host programs 2.1.2
- host table elements
- maximum 7.3.1.1
- host table example 7.4.7
- host tables 7.1
- advantages 7.2
- declaring 7.3.1
- dimensioning 7.3.1.1
- multi-dimensional 7.3.1.1
- operations on 2.1.8
- referencing 7.3.2
- restrictions 7.3.1.1, 7.4.4, 7.5.1, 7.7.1
- restrictions on 7.3.5
- support for 4.3.1.1
- using in dynamic SQL statements 9.15
- using in the DELETE statement 7.7
- using in the INSERT statement 7.5
- using in the SELECT statement 7.4
- using in the UPDATE statement 7.6
- using in the WHERE clause 7.10
- using the FOR clause 7.9
- using to improve performance C.3
- variable-length 7.3.1.1
- host variables 5.1
- assigning a value 2.1.6
- declaring 2.2.1, 2.3.1
- declaring and naming A.1.2
- definition 2.2.16
- host variable equivalencing E.57
- in EXECUTE statement E.23
- initializing 4.3.1.2
- in OPEN statement E.49
- length up to 30 characters 2.1.6
- naming 2.1.6, 4.3.2, 4.3.2.2
- overview 2.1.6
- referencing 2.1.6, 4.3.2
- requirements 2.1.6
- restrictions 2.2.17, 4.3.2.2
- using in PL/SQL 6.4
- where allowed 2.1.6
- with PL/SQL 6.1.1
- hyphenation
- of host variable names 2.2.17
I
- IDE F.1.1
- identifiers, ORACLE
- how to form E.3.6
- implicit logons 3.2.6
- implicit VARCHAR 4.5.2
- INAME option
- when a file extension is required 14.1
- INAME precompiler option 14.7.23
- INCLUDE precompiler option 14.7.24
- INCLUDE statement
- INCLUDE statements A.1.3
- index
- using to improve performance C.7
- index-organized tables 4.7
- indicator table 7.1
- indicator tables
- indicator variable
- indicator variables 5.2
- assigning values to 4.4.1.2
- association with host variables 4.4, 4.4.1
- declaring 2.2.1, 4.4.2
- function 4.4
- function of 4.4.1
- interpreting value 5.2.2
- NULLs 6.1.3.1
- referencing 4.4.3
- required size 4.4.2
- truncated values 6.1.3.2
- used with multibyte character strings 4.9.5
- using in PL/SQL 6.5
- using to detect NULLs 4.4.2
- using to detect truncated values 4.4.2
- using to test for NULLs 5.2.6
- with PL/SQL 6.1.3
- in-doubt transaction 3.13
- IN OUT parameter mode 6.2.4.1
- IN parameter mode 6.2.4.1
- input host variable
- inserting
- rows into tables and views E.30
- INSERT statement E.30
- INTEGER datatype 4.1.2.8
- internal datatype
- definition 2.1.7
- internal datatypes
- dynamic SQL method 4 11.4.2
- INTERVAL DAY TO SECOND datatype 4.2
- INTERVAL YEAR TO MONTH datatype 4.2
- INTO clause 5.1.1, 6.10.4
- IRECLEN precompiler option 14.7.25
- IS NULL operator
- for testing NULL values 2.2.21
L
- language support 1.2.1
- LEVEL pseudocolumns 4.1.2.23
- library file 1.7.2
- line continuation 2.2.7
- linking 2.7
- LITDELIM option
- purpose 14.7.26
- LITDELIM precompiler option 2.2.10, 14.7.26
- LNAME precompiler option 14.7.27
- LOB and precompiler datatypes 13.4.15
- LOB APPEND statement E.31
- LOB ASSIGN statement E.32
- LOB CLOSE statement E.33
- LOB COPY statement E.34
- LOB CREATE statement E.35
- LOB DESCRIBE statement E.36
- LOB DISABLE BUFFERING statement E.37
- LOB ENABLE BUFFERING statement E.38
- LOB ERASE statement E.39
- LOB FILE CLOSE statement E.40
- LOB FILE SET statement E.41
- LOB FLUSH BUFFER statement E.42
- LOB FREE TEMPORARY E.43
- LOB LOAD statement E.44
- LOB OPEN statement E.45
- LOB READ statement E.46
- LOBs
- advantage of buffering 13.1.7
- CHUNKSIZE attribute 13.4.18
- compared with LONG and LONG RAW 13.1.4
- definition 13.1
- DIRECTORY attribute 13.4.18
- external 13.1.2, 13.2.2.2
- FILEEXISTS attribute 13.4.18
- FILENAME attribute 13.4.18
- internal 13.1.1, 13.2.2.1
- ISOPEN attribute 13.4.18
- ISTEMPORARY attribute 13.4.18
- LENGTH attribute 13.4.18
- LOB demo program 13.5
- locators 13.1.5
- rules for all statements 13.3.1
- rules for buffering subsystem 13.3.2
- rules for statements 13.3.3
- temporary 13.1.6, 13.2.2.3
- using polling method to read and write 13.4.19
- LOB statements
- LOB APPEND 13.4.1
- LOB ASSIGN 13.4.2
- LOB CLOSE 13.4.3
- LOB CLOSE ALL 13.4.9
- LOB COPY 13.4.4
- LOB CREATE TEMPORARY 13.4.5
- LOB DISABLE BUFFERING 13.4.6
- LOB ENABLE BUFFERING 13.4.7
- LOB ERASE 13.4.8
- LOB FILE SET 13.4.10
- LOB FLUSH BUFFER 13.4.11
- LOB FREE TEMPORARY 13.4.12
- LOB LOAD FROM FILE 13.4.13
- LOB OPEN 13.4.14
- LOB READ 13.4.15
- LOB TRIM 13.4.16
- LOB WRITE 13.4.17
- LOB TRIM statement E.47
- LOB WRITE statement E.48
- lock
- released by ROLLBACK statement E.52
- locking 3.3, 3.11
- LOCK TABLE statement 3.12.1
- logons
- LONG datatype
- external 4.1.2.9
- LONG RAW datatype
- converting 4.12.5
- LONG RAW datatypes
- external 4.1.2.10
- LONG VARCHAR datatype 4.1.2.11
- LONG VARRAW datatype 4.1.2.12
- LRECLEN precompiler option 14.7.28
- LTYPE precompiler option 14.7.29
M
- MAXLITERAL A.1.4
- MAXLITERAL precompiler option 14.7.31
- MAXOPENCURSORS option C.9
- using for separate precompilation 2.6.1.2
- MAXOPENCURSORS precompiler option 14.7.32
- MERANT Micro Focus COBOL
- message text 8.3.3.5
- MODE
- equivalent values 14.7.33
- mode, parameter 6.2.4.1
- MODE option
- effects of 4.6.2
- MODE precompiler option 14.7.33
- multibyte character sets 4.9
- multibyte Globalization Support features
- with PL/SQL 4.9.1
- multi-byte Globalization Support features
- datatypes 2.2.20
- multithreaded applications
N
- namespaces
- reserved by Oracle B.2
- naming
- naming conventions
- NATIVE
- value of DBMS option 14.7.10
- NESTED precompiler option 14.7.34
- nested programs
- support for 2.4.1
- NetExpress F.1.1
- NEXTVAL pseudocolumns 4.1.2.23
- nibbles 4.12.5
- NLS_LOCAL
- precompiler option 14.7.35
- NOT FOUND condition
- NOWAIT parameter 3.12.1
- using in LOCK TABLE statement 3.12.1
- NULLs
- NULLs in SQL
- how to detect 2.2.21
- NUMBER datatype
- using the SQLPRC subroutine with 11.4.3
- NVL function
- for retrieving NULL values 2.2.21
O
- ONAME precompiler option 14.7.36
- OPEN DESCRIPTOR statement E.50
- opening
- opening a cursor variable 6.10.3
- OPEN SQL statement E.50
- OPEN statement E.49
- operators
- relational 2.2.25
- optimizer hint C.5.1
- optional division headers 2.2.11
- options
- precompiler concepts 14.3
- ORACA 1.7.1, 8.2.2
- declaring 8.4.1, 8.4.2
- enabling 8.4.3
- example 8.4.6
- fields 8.4.5
- gathering cursor cache statistics 8.4.5.11
- ORACABC field 8.4.5.2
- ORACAID field 8.4.5.1
- ORACCHF flag 8.4.5.3
- ORACOC field 8.4.5.14
- ORADBGF flag 8.4.5.4
- ORAHCHF flag 8.4.5.5
- ORAHOC field 8.4.5.12
- ORAMOC field 8.4.5.13
- ORANEX field 8.4.5.17
- ORANOR field 8.4.5.15
- ORANPR field 8.4.5.16
- ORASFNMC field 8.4.5.9
- ORASFNML field 8.4.5.9
- ORASLNR field 8.4.5.10
- ORASTXTC field 8.4.5.8
- ORASTXTF flag 8.4.5.6
- ORASTXTL field 8.4.5.8
- precompiler option 8.4.3
- purpose 8.2.2, 8.4
- structure of 8.4.5
- ORACABC field 8.4.5.2
- ORACAID field 8.4.5.1
- ORACA precompiler option 14.7.22, 14.7.30, 14.7.37, 14.7.39, 14.7.40, 14.7.42, 14.7.52
- ORACCHF flag 8.4.5.3
- Oracle Communications Area
- ORACA 8.4
- Oracle Connection Manager in Traffic Director Mode C.11
- Oracle dynamic SQL
- when to use 10
- Oracle names
- how to form E.3.6
- Oracle namespaces B.2
- Oracle Net
- Oracle Net Services
- concurrent logons 3.2.1
- Oracle Open Gateway
- using ROWID datatype 4.1.2.16
- ORACOC
- in ORACA 8.4.5.14
- ORACOC field 8.4.5.14
- ORADBGF flag 8.4.5.4
- ORAHCHF flag 8.4.5.5
- ORAHOC field 8.4.5.12
- ORAMOC field 8.4.5.13
- ORANEX
- in ORACA 8.4.5.17
- ORANEX field 8.4.5.17
- ORANOR field 8.4.5.15
- ORANPR field 8.4.5.16
- ORASFNM, in ORACA 8.4.5.9
- ORASFNMC field 8.4.5.9
- ORASFNML field 8.4.5.9
- ORASLNR
- in ORACA 8.4.5.10
- ORASLNR field 8.4.5.10
- orasql11.lib library file 1.7.2
- ORASTXTC field 8.4.5.8
- ORASTXTF flag 8.4.5.6
- ORASTXTL field 8.4.5.8
- ORECLEN precompiler option 14.7.38
- OUT parameter mode 6.2.4.1
- output host variable 5.1.1
- output versus input 5.1
P
- PAGELEN precompiler option 14.7.41
- paragraph names
- parameter mode 6.2.4.1
- parse error offset 8.3.3.4
- parsing dynamic statements
- PREPARE statement E.51
- passwords
- performance
- PIC G for Globalization Support characters A.1.5
- PIC N for Globalization Support characters A.1.5
- PICX precompiler option 4.6.1, 14.7.43
- PL/SQL
- PL/SQL block execution
- effect on SQLCA components 8.3.5
- PL/SQL blocks
- embedded in Oracle7 precompiler programs E.22
- PL/SQL subprogram
- calling from Pro*COBOL 6.8
- PL/SQL table 6.2.6
- placeholders
- duplicate 9.16.2
- PLAN_BASELINE
- precompiler option 14.7.44
- PLAN_ENABLED
- precompiler option 14.7.48
- PLAN_FIXED
- precompiler option 14.7.47
- PLAN_PREFIX
- precompiler option 14.7.45
- PLAN_RUN
- precompiler option 14.7.46
- plan, execution C.5
- precompilation
- precompilation unit 14.5
- precompiler command
- required arguments 14.1
- precompiler options
- abbreviating name 14.3
- ANSI Dynamic SQL 10.5
- ASACC 14.7.1
- ASSUME_SQLCODE 14.7.2
- AUTO_CONNECT 3.2.3.1, 14.7.3
- CLOSE_ON_COMMIT 5.4.1, 5.5.2, 14.7.6
- COMP_CHARSET 14.7.7
- CONFIG 14.7.8
- current values 14.3.3
- DATE_FORMAT 14.7.9
- DBMS 14.7.10, 14.7.11
- DECLARE_SECTION 2.3.2, 14.7.12
- DEFINE 14.7.13
- displaying 14.3
- displaying syntax, default, purpose 14.6
- DYNAMIC 10.5, 14.7.14
- END_OF_FETCH 14.7.15
- entering 14.4
- entering inline 14.4.2
- entering on the command line 14.1
- ERRORS 14.7.16
- FIPS 14.7.18
- FORMAT 14.7.19
- HOLD_CURSOR 14.7.20, C.9
- HOST 14.7.21
- INAME 14.7.23
- INCLUDE 14.7.24
- IRECLEN 14.7.25
- list 14.6
- LITDELIM 2.2.10, 14.7.26
- LNAME 14.7.27
- LRECLEN 14.7.28
- LTYPE 14.7.29
- macro and micro 14.3.2
- MAXLITERAL 14.7.31
- MAXOPENCURSORS 2.6.1.2, 14.7.32, C.9
- MODE 4.6.2, 8.2.3, 10.5, 14.7.33
- name of the system configuration file 14.4.3
- NESTED 14.7.34
- NLS_LOCAL 14.7.35
- ONAME 14.7.36
- ORACA 8.4.3, 14.7.22, 14.7.30, 14.7.37, 14.7.39, 14.7.40, 14.7.42, 14.7.52
- ORECLEN 14.7.38
- PAGELEN 14.7.41
- PICX 4.6.1, 14.7.43
- PLAN_BASELINE 14.7.44
- PLAN_ENABLED 14.7.48
- PLAN_FIXED 14.7.47
- PLAN_PREFIX 14.7.45
- PLAN_RUN 14.7.46
- precedence 14.3.1
- PREFETCH 5.4.9, 14.7.49, 14.7.50
- RELEASE_CURSOR 14.7.51, C.9
- respecifying 14.5
- scope of 14.5
- SELECT_ERROR 14.7.53
- specifying 14.1
- SQLCHECK 14.7.54
- syntax for 14.1
- table of how macro options set micro options 14.3.2
- THREADS 12.4.1
- TYPE_CODE 10.5, 14.7.55, 14.7.56
- UNSAFE_NULL 14.7.57
- USERID 14.7.58
- VARCHAR 14.7.59
- XREF 14.7.60
- precompilers
- PREFETCH precompiler option 5.4.9, 5.5.3, 14.7.49, 14.7.50
- PREPARE statement E.51
- private SQL area
- Pro*COBOL
- how it works 1.2
- programming guidelines 2.2
- programming language support 1.2.1
- program termination 3.9
- pseudocolumns 4.1.2.23
R
- RAW datatype
- RAWTOHEX function 4.12.5
- read consistency 3.3
- READ ONLY parameter
- using in SET TRANSACTION 3.10
- read-only transaction 3.10
- record, user-defined 6.2.7
- REDEFINES clause
- reference
- host variable 2.1.6
- reference cursor 6.10
- referencing
- relational operators
- COBOL versus SQL 2.2.25
- RELEASE_CURSOR option C.9
- of ORACLE Precompilers E.7
- RELEASE_CURSOR precompiler option 14.7.51
- RELEASE option 3.6, 3.9
- remote database
- declaration of E.15
- restrictions
- AT clause 3.2.2.1
- CURRENT OF clause 5.4.6
- cursor declaration 5.4.1
- cursor variables 6.10.7
- dynamic SQL 14.7.35
- FOR clause 7.9.1
- host tables 7.3.1.1, 7.4.4, 7.5.1, 7.7.1
- host variables 4.3.2.2
- input host variable 5.1.1
- on host tables 7.3.5
- REDEFINES clause 2.2.23
- RELEASE option 3.8
- separate precompilation 2.6.1.1
- SET TRANSACTION statement 3.10
- SQLGLM subroutine 8.3.6
- SQLIEM subroutine 8.3.6
- TO SAVEPOINT clause 3.8
- use of CURRENT OF clause 7.3.5
- retrieving rows from a table
- embedded SQL E.54
- RETURN-CODE special register is unpredictable A.1.6
- returning clause 5.3.3
- in INSERT 5.3.3
- rollback
- roll back
- rollback segments 3.3
- ROLLBACK statement 3.7, E.52
- rolling back
- transactions E.52
- ROWID datatype
- ROWID pseudocolumns
- row lock
- ROWNUM pseudocolumns 4.1.2.23
- rows
- rows-processed count 8.3.3.3
- RR diagrams
- see syntax diagrams E.3
S
- sample database table
- sample programs
- calling a stored procedure 6.9
- cursor operations 5.8
- cursor variables
- PL/SQL source 6.10.8.1
- cursor variable use 6.10.8
- datatype equivalencing 4.14
- dynamic SQL Method 1 9.8
- dynamic SQL method 2 9.10
- dynamic SQL Method 3 9.12
- dynamic SQL method 4 11.8
- EXEC ORACLE scope 14.4.2.2
- fetching in batches 7.4.7, 7.13
- LOBDEMO1.PCO 13.5
- location of 1.7
- PL/SQL examples 6.4.1
- SAMPLE1.PCO 2.9
- SAMPLE10.PCO 11.8
- SAMPLE11.PCO 6.10.8
- SAMPLE12.PCO 10.7
- SAMPLE13.PCO 2.4.1.2
- SAMPLE14.PCO 7.13
- SAMPLE2.PCO 5.8
- SAMPLE3.PCO 7.4.7
- SAMPLE4.PCO 4.14
- SAMPLE6.PCO 9.8
- SAMPLE7.PCO 9.10
- SAMPLE8.PCO 9.12
- SAMPLE9.PCO 6.9
- simple query 2.9
- tables of group items 7.13
- WHENEVER...DO CALL example 8.3.9.2
- savepoint 3.8
- savepoints
- SAVEPOINT statement 3.8, E.53
- scalar types 11.4.3
- scale
- scope
- search condition 5.3.7
- using in the WHERE clause 5.3.7
- SELDFCLP variable (SQLDA) 11.3
- SELDFCRCP variable (SQLDA) 11.3
- SELDFMT variable (SQLDA) 11.3
- SELDH-CUR-VNAMEL variable (SQLDA) 11.3
- SELDH-MAX-VNAMEL variable (SQLDA) 11.3
- SELDH-VNAME variable (SQLDA) 11.3
- SELDI-CUR-VNAMEL variable (SQLDA) 11.3
- SELDI-MAX-VNAMEL variable (SQLDA) 11.3
- SELDI variable (SQLDA) 11.3
- SELDI-VNAME variable (SQLDA) 11.3
- SELDVLN variable (SQLDA) 11.3
- SELDVTYP variable (SQLDA) 11.3
- SELDV variable (SQLDA) 11.3
- SELECT_ERROR option 5.3.1
- SELECT_ERROR precompiler option 14.7.53
- select descriptor 11.2.1
- select descriptors
- information in 9.13.2
- select list 5.3.1
- select-list items
- naming 11.2.1
- select SQLDA
- purpose of 11.1.3
- SELECT statement E.54
- semantic checking D.1
- separate precompilation
- session 3.3
- sessions
- beginning E.9
- SET clause 5.3.5
- using a subquery 5.3.5
- SET DESCRIPTOR statement E.55
- SET TRANSACTION statement
- snapshot 3.3
- SQL
- summary of statements E.1
- SQL_CURSOR E.4
- SQL*Plus 1.4
- SQLADR subroutine
- SQLCA 1.7.1, 8.2.1
- components set for a PL/SQL block 8.3.5
- declaring EXTERNAL 2.6.1.3
- fields 8.3.4
- interaction with Oracle 2.1.9.2
- overview 2.1.9.2
- sharing 2.6.1.3
- SQLCABC field 8.3.4.2
- SQLCAID field 8.3.4.1
- SQLCODE field 8.3.4.4
- SQLERRD(3) field 8.3.4.5
- SQLERRD(5) field 8.3.4.5
- SQLERRMC field 8.3.4.4
- SQLERRML field 8.3.4.4
- SQLWARN(4) flag 8.3.4.6
- using with Oracle Net Services 8.3
- SQLCABC field 8.3.4.2
- SQLCAID field 8.3.4.1
- SQLCA status variable
- SQLCHECK option
- SQLCHECK precompiler option 14.7.54
- SQLCODE field 8.3.4.4
- interpreting its value 8.3.4.4
- SQL codes
- returned by SQLGLS routine 8.3.10
- SQLCODE status variable
- SQL Communications Area 2.1.9.2
- SQL-CONTEXT 12.4.2
- SQLDA 1.7.1, 9.13.1, 9.13.3
- bind versus select 9.13.3
- BNDDFCLP variable 11.3
- BNDDFCRCP variable 11.3
- BNDDFMT variable 11.3
- BNDDH-CUR-VNAMEL variable 11.3
- BNDDH-MAX-VNAMEL variable 11.3
- BNDDH-VNAME variable 11.3
- BNDDI-CUR-VNAMEL variable 11.3
- BNDDI-MAX-VNAMEL variable 11.3
- BNDDI variable 11.3
- BNDDI-VNAME variable 11.3
- BNDDVLN variable 11.3
- BNDDVTYP variable 11.3
- BNDDV variable 11.3
- declaring 11.2.3
- example 11.2.3
- information stored in 9.13.3
- purpose 11.2.1
- SELDFCLP variable 11.3
- SELDFCRCP variable 11.3
- SELDFMT variable 11.3
- SELDH-CUR-VNAMEL variable 11.3
- SELDH-MAX-VNAMEL variable 11.3
- SELDH-VNAME variable 11.3
- SELDI-CUR-VNAMEL variable 11.3
- SELDI-MAX-VNAMEL variable 11.3
- SELDI variable 11.3
- SELDI-VNAME variable 11.3
- SELDVLN variable 11.3
- SELDVTYP variable 11.3
- SELDV variable 11.3
- SQLADR subroutine 11.4.1
- SQLDFND variable 11.3
- SQLDNUM variable 11.3
- structure 11.3
- SQL Descriptor Area 9.13.1, 11.2
- SQLDFND variable (SQLDA) 11.3
- SQL directives
- SQL directives CONTEXT USE E.12
- SQLDNUM variable (SQLDA) 11.3
- SQLERRD(3) field 8.3.4.5
- using with batch fetch 7.4.3
- SQLERRD(3) variable 8.3.3.3
- SQLERRD(5) field 8.3.4.5
- SQLERRMC field 8.3.4.4
- SQLERRMC variable 8.3.3.5
- SQLERRML field 8.3.4.4
- SQLERROR condition 8.3.8.3
- SQLFC parameter 8.3.10
- SQLGLM subroutine
- SQLGLS routine 8.3.10
- SQLIEM subroutine
- restrictions 8.3.6
- SQLNUL subroutine
- SQLPRC subroutine
- SQLROWIDGET
- retrieving ROWID of last row inserted 4.7.1
- SQLSTATE
- declaring 8.2.4
- SQL statements
- ALLOCATE E.4
- ALLOCATE DESCRIPTOR E.5
- CALL E.6
- CLOSE E.7
- COMMIT E.8
- CONNECT E.9
- CONTEXT ALLOCATE E.10
- CONTEXT FREE E.11
- controlling transactions 3.4
- DEALLOCATE DESCRIPTOR E.13
- DELETE E.18
- DESCRIBE E.19
- DESCRIBE DESCRIPTOR E.20
- ENABLE THREADS E.21
- EXECUTE E.23
- EXECUTE...END-EXEC E.22
- EXECUTE DESCRIPTOR E.24
- EXECUTE IMMEDIATE E.25
- FETCH E.26, E.27
- FETCH DESCRIPTOR E.27
- FREE E.28
- GET DESCRIPTOR E.29
- INSERT E.30
- LOB APPEND E.31
- LOB ASSIGN E.32
- LOB CLOSE E.33
- LOB COPY E.34
- LOB CREATE E.35
- LOB DESCRIBE E.36
- LOB DISABLE BUFFERING E.37
- LOB ENABLE BUFFERING E.38
- LOB ERASE E.39
- LOB FILE CLOSE E.40
- LOB FILE SET E.41
- LOB FLUSH BUFFER E.42
- LOB FREE TEMPORARY E.43
- LOB LOAD E.44
- LOB OPEN E.45
- LOB READ E.46
- LOB TRIM E.47
- LOB WRITE E.48
- OPEN E.49, E.50
- OPEN DESCRIPTOR E.50
- optimizing to improve performance C.5
- PREPARE E.51
- ROLLBACK E.52
- SAVEPOINT E.53
- SELECT E.54
- SET DESCRIPTOR E.55
- static versus dynamic 2.1.4
- summary of E.1
- UPDATE E.56
- using to control a cursor 5.3, 5.4
- SQLSTATE status variable
- SQLSTM parameter 8.3.10
- SQLSTM routine 8.3.10
- SQLWARN(4) flag 8.3.4.6
- SQLWARNING
- condition WHENEVER directive E.58
- SQLWARNING condition 8.3.8.2
- of WHENEVER directive 8.3.8.2
- statement-level rollback 3.7.1
- breaking deadlocks 3.7.1
- status codes for error reporting 8.3.3.1
- STMLEN parameter 8.3.10
- STOP action
- stored procedure
- stored procedures
- stored subprogram
- stored subprogram, calling 6.8
- STRING datatype 4.1.2.17
- string literals
- continuing on the next line 2.2.7
- subprogram, PL/SQL 6.2.4
- subprogram, PL/SQL or Java 6.8
- subquery 5.3.4
- syntactic checking D.1
- syntax
- syntax, embedded SQL 2.1.3
- syntax diagrams
- SYSDATE function 4.1.2.23
- SYSDBA privilege show to set 3.2.5.2
- SYSOPER privilege
- how to set 3.2.5.2
- system failures
- effect on transactions 3.5
- System Global Area (SGA) 6.8
T
- table (host) elements
- maximum 7.3.1.1
- table lock
- tables
- tables, host 7.1
- TERMINAL format
- COBOL statements 2.2.4
- terminator for embedded SQL statements 2.2.25
- threads E.10
- THREADS
- precompiler option 12.4.1
- TIMESTAMP datatype 4.2
- TIMESTAMP WITH LOCAL TIME ZONE datatype 4.2
- TIMESTAMP WITH TIME ZONE datatype 4.2
- TO SAVEPOINT clause 3.8
- trace facility
- using to improve performance C.5.1.1
- transaction 3.4
- transactions
- truncated values 6.5.2
- truncation errors
- when generated 5.2.7
- tuning, performance C.1
- TYPE_CODE option
- effect on functionality 10.5
- TYPE_CODE precompiler option 14.7.55, 14.7.56
- TYPE statements
- using the CHARF datatype specifier 4.12.3
U
- UID function 4.1.2.23
- undo a transaction E.52
- universal ROWID
- ROWID pseudocolumns 4.7
- UNSAFE_NULL precompiler option 14.7.57
- UNSIGNED datatype 4.1.2.18
- UPDATE statement E.56
- updating
- rows in tables and views E.56
- use
- thread context 12.4.2.4
- user-defined record 6.2.7
- USER function 4.1.2.23
- USERID option
- using with the SQLCHECK option D.3.1.1
- USERID precompiler option 14.7.58
- usernames
- user session 3.3
- USING clause
- using dbstring
- Oracle Net Services database id specification E.9
V
- V7
- value of DBMS option 14.7.10
- VALUE clause
- initializing host variables 4.3.1.2
- VALUES clause
- VARCHAR2 datatype
- external 4.1.2.20
- VARCHAR datatype 4.1.2.19
- VARCHAR precompiler option 14.7.59
- VARCHAR pseudotype
- using with PL/SQL 6.4.3
- VARCHAR variables
- advantages 4.6.4.2
- as input variables 4.6.4.1
- as output variables 4.6.4.2
- declaring 4.5.1
- implicit group items 4.5.2
- length element 4.5.1
- maximum length 4.5.1
- referencing 4.5.3
- server handling 4.6.4.1, 4.6.4.2
- string element 4.5.1
- structure 4.5.1
- versus fixed-length strings 4.6.4.2
- with PL/SQL 6.1.2
- VAR directive E.57
- examples E.57
- VARNUM datatype 4.1.2.21
- VARRAW datatype 4.1.2.22
- VAR statement
- VARYING keyword
- versus VARYING phrase 4.5.1
- versions of COBOL supported 2.2.3
- views
W
- warning flags for error reporting 8.3.3.2
- WHENEVER
- DO CALL example 8.3.9.2
- WHENEVER directive 8.3.8, E.58
- careless usage 8.3.9.4
- CONTINUE action 8.3.8.6
- DO CALL action 8.3.8.7
- DO PERFORM action 8.3.8.8
- example 8.3.9.1
- examples E.58
- GOTO action 8.3.8.9
- overview 2.1.9.3
- purpose 8.3.8
- scope of 8.3.9.3
- SQLERROR condition 8.3.8.3
- SQLWARNING condition 8.3.8.2
- STOP action 8.3.8.10
- syntax 8.3.9
- using to check SQLCA automatically 8.3.8.1
- WHERE clause 5.3.7
- WHERE CURRENT OF clause 5.4.5
- WITH HOLD
- clause of DECLARE CURSOR statement 5.4.1
- WORK option