1. Index

Index

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

Symbols

  • .dsp files F.4
  • .pre files
    • checking the paths F.5
  • #include
    • file inclusion, Pro*C compared to C 5.4.1

A

  • abnormal termination
    • automatic rollback E.15
  • active set
  • ALLOCATE
    • allocating a cursor variable 4.5.2
  • ALLOCATE DESCRIPTOR statement 14.5.1, E.5
  • ALLOCATE SQL statement 17.4.2
  • ALLOCATE SQL statements E.4
  • allocating
  • ANSI C Support D.1.3
  • ANSI dynamic SQL F.1
    • reference semantics 14.3.1
    • See also dynamic SQL (ANSI) 14
  • application development process 2.2
  • ARRAYLEN statement 7.5.1
  • array of structs 8.10
  • arrays
    • batch fetch 8.4.1
    • bulk operations (ANSI dynamic SQL) 14.3.2
    • chapter discusses how to use 8
    • definition of 4.8.1
    • host arrays 2.1.7
    • operations 2.1.7
    • varying length 18.1.2
  • associative interface 17.4
  • AT clause
    • in CONNECT statement 3.2.4.1
    • in DECLARE CURSOR statement 3.2.4.1.3
    • in DECLARE STATEMENT statement 3.2.4.1.4
    • in EXECUTE IMMEDIATE statement 3.2.4.1.4
    • of COMMIT statement E.15
    • of DECLARE CURSOR directive E.23
    • of EXECUTE IMMEDIATE statement E.35
    • of EXECUTE statement E.32
    • of INSERT statement E.40
    • of SAVEPOINT statement E.72
    • of SELECT statement E.73
    • of SROLLBACK statement E.71
    • of UPDATE statement E.76
    • restriction on 3.2.4.1.3
    • use of 3.2.4.1.3
  • attributes of a collection
  • AUTO_CONNECT 10.5.1
  • AUTO_CONNECT precompiler option 10.5.1
  • automatic connections 3.1.3, 3.2.4

B

C

D

  • database link
  • databases
  • database types
  • data definition language
    • in transactions 3.5
  • data integrity 3.2.4.3
    • definition of 3.3
  • data locks 3.3
  • datatype equivalencing 2.1.8
  • datatypes
  • DATE, ANSI
  • DATE datatype 4.1.2.10
  • datetime
    • avoiding unexpected results 4.1.3.8
  • DBMS interaction with MODE 10.5.16
  • DBMS option 5.3.3, 10.2.7.3
  • DBMS precompiler option 10.5.15, 10.5.16
  • deadlock
    • definition of 3.3
    • effect on transactions 3.8.1
    • how broken 3.8.1
  • DEALLOCATE DESCRIPTOR statement 14.5.2, E.22
  • declaration
  • declarative SQL statements
    • in transactions 3.5
  • DECLARE CURSOR directives
  • DECLARE CURSOR statement 14.5.10
  • DECLARE DATABASE SQL directives E.24
  • Declare Section
  • DECLARE statement
  • DECLARE STATEMENT directive E.25
  • DECLARE statements
  • DECLARE STATEMENT statement
  • DECLARE TABLE directive
  • DECLARE TABLE SQL directive E.26
  • DECLARE TABLE statement
  • DECLARE TYPE directive E.27
  • DEF_SQLCODE precompiler option 10.5.17
  • default connections 3.2.3
  • default database 3.2.3
  • default file name extensions 19.5.7
  • DEFINE precompiler option 10.5.18
    • used in application migration 5.4.9
  • defining symbols 2.4.1
  • DELETE SQL statement E.28
  • DELETE statement
  • delimiters
  • DEPT table 2.7
  • DESCRIBE BIND VARIABLES statement
    • use in dynamic SQL method 4 15.6.8
  • DESCRIBE command
    • use with PREPARE command E.29
  • DESCRIBE DESCRIPTOR statement E.30
  • DESCRIBE INPUT statement 14.5.6
  • DESCRIBE OUTPUT statement 14.5.7
  • DESCRIBE SELECT LIST statement
    • use in dynamic SQL method 4 15.6.12
  • DESCRIBE SQL statement E.29
  • DESCRIBE statement
  • descriptions of collection attributes 18.4.6
  • descriptors 15.2.1
  • determining current value of precompiler options 10.2.3
  • directory structures 1.6
  • distributed processing
  • distributed transactions E.71
  • DML returning clauses 6.4
  • DO action
  • DTP model 5.12
  • dummy host variables
  • DURATION precompiler option 10.5.20, 17.8.2
  • Dynamic Link Libraries (DLLs) 1.7
  • dynamic PL/SQL
  • dynamic SQL
    • advantages and disadvantages of 13.2
    • cannot use cursor variables with 4.5.6
    • choosing the right method 13.6.5
    • definition of 2.1.3
    • guidelines for 13.6.5
    • method 1 F.1
    • method 2 F.1
    • method 3 F.1
    • method 4 F.1
    • overview of 13.1
    • restriction on 6.9.1
    • restrictions on use of datatypes 17.16
    • restrictions on using datatypes in 17.16
    • uses for 13.2
    • using the AT clause in 3.2.4.1.4
    • when to use 13.3
  • dynamic SQL (ANSI)
  • dynamic SQL method 1
  • dynamic SQL method 2
  • dynamic SQL method 3
  • dynamic SQL method 4
  • dynamic SQL methods
  • dynamic SQL statements
    • binding of host variables in 13.5
    • definition of 13.1
    • requirements for 13.4
    • use of placeholders in 13.4
    • using host arrays in 13.11.1
    • versus static SQL statements 13.1

E

  • embedded PL/SQL
  • embedded SQL F.1
    • ALLOCATE statement E.4
    • CLOSE statement E.8
    • CONTEXT ALLOCATE statement 11.4.2.2, E.17
    • CONTEXT FREE statement 11.4.2.4
    • definition of 2.1.1
    • difference from interactive SQL 2.1.2
    • ENABLE THREADS statement 11.4.2.1
    • EXEC SQL CACHE FREE ALL 17.4.4
    • EXECUTE statement E.32
    • key concepts of 2.1
    • mixing with host-language statements 2.1.2
    • OPEN statement E.67
    • overview of 2.1.1
    • PREPARE statement E.69
    • requirements for 2.1.2
    • SAVEPOINT statement E.72
    • SELECT statement E.73
    • syntax for 2.1.2
    • testing with SQL*Plus 1.3
    • TYPE directive E.75
    • UPDATE statement E.76
    • using OCI types in 17.14.2
    • using REFs in 17.13.3
    • VAR directive E.77
    • WHENEVER directive E.78
    • when to use 1.3
  • embedded SQL statements
    • labels for 9.8.2.5
    • referencing host arrays in 8.3.1
    • referencing host variables in 4.2.2
    • suffixes and prefixes not allowed 2.3.2
    • terminator for 2.3.13
    • use of apostrophes in 2.3.4
    • use of quotation marks in 2.3.4
  • embedding
    • PL/SQL blocks in precompiler programs E.32
  • EMP table 2.7
  • ENABLE THREADS SQL statement E.31
  • ENABLE THREADS statement 11.4.2.1
  • enabling
  • encoding scheme (character set or code page) 4.10
  • enqueues
  • entering options 10.4
  • environment variables 10.2.1
  • equivalencing
    • host variable equivalencing E.77
    • user-defined type equivalencing E.75
  • equivalencing of datatypes
    • datatype equivalencing 2.1.8
  • error detection
    • error reporting E.78
  • error handling 2.1.11
    • alternatives 9.2
    • need for 9.1
    • overview of 2.1.11
    • SQLCA versus WHENEVER statement 9.2.2
    • use of ROLLBACK statement in 3.8
  • error messages
    • maximum length of 9.7
    • using the sqlglm() function to get 9.7
  • error reporting
    • key components of 9.5
    • use of parse error offset in 9.5.4
    • use of rows-processed count in 9.5.3
    • use of warning flags in 9.5.2
    • WHENEVER directive E.78
  • ERRORS precompiler option 10.5.21
  • ERRTYPE
  • ERRTYPE OTT parameter 19.5.2.9
  • ERRTYPE precompiler option 17.8.5
  • exception, PL/SQL
  • EXEC ORACLE DEFINE statement 5.6
  • EXEC ORACLE ELSE statement 2.4, 5.6
  • EXEC ORACLE ENDIF statement 2.4, 5.6
  • EXEC ORACLE IFDEF statement 2.4, 5.6
  • EXEC ORACLE IFNDEF statement 2.4, 5.6
  • EXEC ORACLE OPTION statement
    • set option values inline 10.4
  • EXEC ORACLE statement
  • EXEC ORACLE statements 2.4
  • EXEC SQL CACHE FREE statement 17.4.4
  • EXEC SQL clause
    • using to embed SQL 2.1.2
  • EXEC SQL INCLUDE
    • contrasted with #include 5.4.8
  • EXEC SQL VAR statement
  • EXEC TOOLS
  • EXEC TOOLS statements 20.5
  • executable SQL statements
  • EXECUTE ... END-EXEC SQL statement E.32
  • EXECUTE DESCRIPTOR statement
    • SQL statements
      • EXECUTE DESCRIPTOR E.34
  • EXECUTE IMMEDIATE SQL statement E.35
  • EXECUTE IMMEDIATE statement 14.5.9
  • EXECUTE optional keyword of ARRAYLEN statement 7.5.2
  • EXECUTE SQL statement E.33
  • EXECUTE statement 14.5.8
  • execution of statements 13.5
  • execution plan B.5, B.5.2
  • EXPLAIN PLAN statement
    • function of B.5.2
    • using to improve performance B.5.2
  • explicit connections 3.2.4
  • extensions
  • external datatypes
  • external procedures

F

  • FAQs 1.8
  • FETCH DESCRIPTOR SQL statement E.37
  • fetching
  • fetching in batches
  • FETCH SQL statement E.36
  • FETCH statement 14.5.12
  • FIPS flagger
    • warns of array usage 8.3.4
    • warns of missing Declare Section 4.2.1
    • warns of use of pointers as host variables 5.1.3.3
  • FIPS precompiler option 10.5.24
  • flags
  • FLOAT datatype 4.1.2.4
  • FORCE clause
    • of COMMIT statement E.15
    • of ROLLBACK statement E.71
  • FOR clause
    • example of using 8.8
    • of embedded SQL EXECUTE DESCRIPTOR statement E.34
    • of embedded SQL EXECUTE statement E.33
    • purpose of 8.8
    • requirements for 8.8
    • restrictions on 8.8.1
    • using with host arrays 8.8
    • when variable negative or zero 8.8
  • FOR UPDATE OF clause
  • forward references
  • free() function 15.6.17
  • freeing
  • FREE SQL statement 17.4.3, E.38
  • Frequently Asked Questions 1.8
  • full scan
    • description of B.7
  • function prototype
  • functions
    • cannot serve as host variables 4.2.2.1
  • F variable in SQLDA

G

  • generic documentation references
    • default values for options 10.2.7
    • header files, location of 5.5.4
    • linking 1.7
  • GENXTB form
  • GENXTB utility
  • GET DESCRIPTOR statement 14.5.3
  • Globalization Support 4.10
  • GOTO action
  • guidelines
    • for dynamic SQL 13.6.5
    • for separate precompilations 2.5.1
    • for the WHENEVER statement 9.8.6
    • for transactions 3.14.1

H

  • header files
  • HEADER precompiler option 5.5, 10.5.25
  • heap
  • HFILE OTT parameter 19.5.2.7
  • hints
    • COST B.5.1
    • for the ORACLE SQL statement optimizer 6.7
    • in DELETE statements E.28
    • in SELECT statements E.73
    • in UPDATE statements E.76
  • HOLD_CURSOR
    • precompiler option
      • used to improved performance B.9.2.4
      • what it affects B.9
  • HOLD_CURSOR option
    • of ORACLE Precompilers E.8
  • HOLD_CURSOR precompiler option 10.5.25
  • host arrays
    • advantages of 8.1
    • declaring 8.2
    • dimensioning 8.2
    • in the DELETE statement 8.7
    • in the INSERT statement 8.5
    • in the SELECT statement 8.4
    • in the UPDATE statement 8.6
    • in the WHERE clause 8.9
    • matching sizes of 8.3.1
    • referencing 8.2.1, 8.3.1
    • restrictions on 8.3.3, 8.4.7, 8.5.1, 8.6.1, 8.7.1
    • used as input host variables 8.3
    • used as output host variables 8.3
    • using in dynamic SQL statements 13.11.1
    • using the FOR clause with 8.8
    • using to improve performance B.3
    • when not allowed 8.2.1
  • host language
  • host program
  • host structures
  • host variables 6.1.1

I

  • IAP in SQL*Forms
  • identifiers, ORACLE
  • implicit connections 3.2.5
  • INAME precompiler option 10.5.28
  • INCLUDE
    • using to include the SQLCA 9.6.1
  • INCLUDE, SYS_INCLUDE Precompiler Options 10.2.1
  • INCLUDE option 10.2.7.4
  • INCLUDE precompiler option D.1.11
  • indexes
    • using to improve performance B.7
  • indicator arrays 8.3.2
  • INDICATOR keyword 4.3.1
  • indicator variables
    • assigning values to 6.2
    • association with host variables 6.2
    • declarations 18.2.1
    • declaring 4.3, 18.2.1
    • definition of 2.1.5
    • function of 6.2
    • guidelines 4.3.3
    • interpreting values of 6.2
    • naming of 4.8.4
    • referencing 4.3
    • requirements for 6.2
    • used with multibyte character strings 4.11.6
    • using in PL/SQL 7.4
    • using to detect NULLs 6.2
    • using to detect truncated values 6.2
    • using to insert NULLs 6.2.1
    • using to return NULLs 6.2.2
    • using to test for NULLs 6.2.4
    • with structures 4.8.4
  • in-doubt transaction 3.13
  • INITFILE OTT parameter 19.5.2.5
  • INITFUNC OTT parameter 19.5.2.6
  • initialization function
  • IN OUT parameter mode 7.1.4
  • IN parameter mode 7.1.4
  • input host variables
  • inserting
    • rows into tables and views E.40
  • INSERT SQL statement E.40
  • INSERT statement
  • INTEGER datatype 4.1.2.3
  • interface
  • internal datatypes
  • INTERVAL DAY TO SECOND datatype 4.1.3.7
  • INTERVAL YEAR TO MONTH datatype 4.1.3.6
  • INTO clause
    • for output host variables 6.1.1
    • in FETCH statements 6.5.3
    • in INSERT statements 6.3.2
    • in SELECT statements 6.3.1
    • of FETCH DESCRIPTOR statement E.37
    • of FETCH statement E.36
    • of SELECT statement E.73
    • used with FETCH instead of SELECT 6.5.1
  • intype file 19.5.4
  • INTYPE OTT parameter 19.5.2.2
  • INTYPE precompiler option 10.5.30
  • invalid use
    • of precompiler preprocessor 5.4.5.1
  • I variable in SQLDA

J

  • joins

L

  • label name
  • large objects F.1
  • LDA 5.10
    • remote and multiple connections 5.10.2
    • setup for OCI version 8 5.10.1
  • lines
  • LINES precompiler option 10.5.31
  • link
  • linking 1.7, 2.6
  • Linking in an XA Library D.1.8
  • LNAME precompiler option 10.5.32
  • LNPROC
  • LOB APPEND SQL statement E.41
  • LOB APPEND statement 16.4.1
  • LOB ASSIGN SQL statement E.42
  • LOB ASSIGN statement 16.4.2
  • LOB CLOSE SQL statement E.43
  • LOB CLOSE statement 16.4.3
  • LOB COPY SQL statement E.44
  • LOB COPY statement 16.4.4
  • LOB CREATE TEMPORARY SQL statement E.45
  • LOB CREATE temporary statement 16.4.5
  • LOB DESCRIBE SQL statement E.46
  • LOB DISABLE BUFFERING SQL statement E.47
  • LOB DISABLE BUFFERING statement 16.4.6
  • LOB ENABLE BUFFERING SQL statement E.48
  • LOB ENABLE BUFFERING statement 16.4.7
  • LOB ERASE SQL statement E.49
  • LOB ERASE statement 16.4.8
  • LOB FILE CLOSE ALL SQL statement E.50
  • LOB file close all statement 16.4.9
  • LOB FILE CLOSE ALL statement 16.4.9
  • LOB FILE SET SQL statement E.51
  • LOB FILE SET statement 16.4.10
  • LOB FLUSH BUFFER SQL statement E.52
  • LOB FLUSH BUFFER statement 16.4.11
  • LOB FREE TEMPORARY SQL statement E.53
  • LOB FREE TEMPORARY statement 16.4.12
  • LOB LOAD FROM FILE statement 16.4.13
  • LOB LOAD SQL statement E.54
  • LOB OPEN SQL statement E.55
  • LOB OPEN statement 16.4.14
  • LOB READ SQL statement E.56
  • LOB READ statement 16.4.15
  • LOBs F.1
  • LOB TRIM SQL statement E.57
  • LOB WRITE SQL statement E.58
  • Location of Included Files D.1.2
  • location of the Pro*C/C++ Executable D.1.9
  • location transparency
  • lock
    • released by ROLLBACK statement E.71
  • locking 3.11
    • definition of 3.3
    • explicit versus implicit 3.11
    • modes of 3.3
    • overriding default 3.11
    • privileges needed to obtain 3.14.2
    • table versus row 3.11
    • uses for 3.11
    • with FOR UPDATE OF 3.11
    • with the LOCK TABLE statement 3.11.2
  • LOCK TABLE statement
  • logon 3.1
  • Logon Data Area 5.10
  • LONG datatype 4.1.2.7
  • LONG RAW datatype 4.1.2.13
  • LONG VARCHAR
  • LONG VARRAW datatype 4.1.2.16
  • LTYPE precompiler option 10.5.33
  • L variable in SQLDA

M

  • macro precompiler options 10.2.4
  • malloc()
  • MAXLITERAL
  • MAXLITERAL precompiler option 10.5.35
  • MAXOPENCURSORS
    • precompiler option
      • effect on performance B.9.2.2
      • specifying for separate precompilation 2.5.1.2
      • what it affects B.9
  • MAXOPENCURSORS precompiler option 10.5.36
  • MEMFORPREFETCH precompiler option 10.5.53
  • metadata 18.4.7
  • micro precompiler options 10.2.4
  • Microsoft Visual Studio
    • integrating Pro*C/C++ into G
  • migration
  • MODE interaction with DBMS 10.5.16
  • MODE precompiler option 10.5.37
  • modes, parameter 7.1.4
  • msvcrt.lib runtime library 1.7
  • multithreaded applications F.1
    • sample program 11.5
    • user-interface features
      • embedded SQL statements and directives 11.4.2
  • M variable in SQLDA

N

O

P

Q

  • queries
    • association with cursors 6.5
    • forwarding 3.2.5.1
    • incorrectly coded 6.3.1
    • kinds of 6.3
    • requirements for 6.3
    • returning more than one row 6.3

R

  • RAW datatype 4.1.2.11
  • READ ONLY parameter
    • in SET TRANSACTION statement 3.10
  • read-only transactions
  • record 7.1.7
  • REF
  • REF (reference to object) 17.1.2
  • REFERENCE clause
  • reference semantics (ANSI dynamic SQL) 14.3.1
  • references to objects (REFs)
  • referencing
  • REFs
  • REGISTER CONNECT SQL statement E.70
  • RELEASE_CURSOR
    • precompiler option
      • what it affects B.9
  • RELEASE_CURSOR option
    • of ORACLE Precompilers E.8
    • using to improve performance B.9.2.4
  • RELEASE_CURSOR precompiler option 10.5.55
  • RELEASE option 3.9
    • if omitted 3.9
    • in COMMIT statement 3.6
    • in ROLLBACK statement 3.8
    • purpose of 3.6
    • restriction on 3.8
  • remote database
    • declaration of E.24
  • reserved namespaces A.2
  • reserved words and keywords A.1
  • resource manager 5.12
  • restrictions
  • retrieving rows from a table
  • return codes
  • returning clause
  • returning clauses 6.4
  • roll back
    • to a savepoint E.72
    • to the same savepoint multiple times E.71
  • rollbacks
  • ROLLBACK SQL statement E.71
  • ROLLBACK statement
    • effect of 3.8
    • ending a transaction E.71
    • example of 3.8
    • examples E.71
    • in error handling routines 3.8
    • purpose of 3.8
    • RELEASE option in 3.8
    • TO SAVEPOINT clause in 3.8
    • using in a PL/SQL block 3.14.3
    • where to place 3.8
  • ROWID
  • ROWID datatype 4.1.2.9
  • row locks
  • rows
    • fetching from cursors E.36, E.37
    • inserting into tables and views E.40
    • updating E.76
  • rows-processed count
    • use in error reporting 9.5.3
  • runtime context
  • runtime type checking 17.8.7

S

  • sample database tables
    • DEPT table 2.7
    • EMP table 2.7
  • sample object type code 17.11
  • sample programs
  • sample tables
  • savepoints
  • SAVEPOINT SQL statement E.72
  • SAVEPOINT statement E.72
  • scale
  • Scale
    • using SQLPRC to extract E.77
  • SCHEMA_NAMES OTT parameter 19.5.2.11
  • scope
    • of a cursor variable 4.5.1
    • of DECLARE STATEMENT directive E.25
    • of precompiler options 10.3
    • of the EXEC ORACLE statement 10.4.2.2
    • of WHENEVER statement 9.8.5
  • search condition
  • SELECT_ERROR
  • select descriptor 15.2.1
  • select list
    • definition of 6.3.1
    • number of items in 6.3.1
    • using the free() function for 15.6.17
    • using the malloc() function for 15.6.14
  • select SQLDA
  • SELECT SQL statement E.73
  • SELECT statement 6.3.1
  • semantic checking
    • controlling with the SQLCHECK option C.2
    • definition of C.1
    • enabling C.3.1
    • with the SQLCHECK option C.1
  • separate precompilation
  • server
    • integration with PL/SQL 7.1.2
  • session
    • definition of 3.3
  • sessions
  • SET clause
  • SET DESCRIPTOR statement 14.5.4, E.74
  • SET TRANSACTION statement
    • example of 3.10
    • purpose of 3.10
    • READ ONLY parameter in 3.10
    • requirements for 3.10
    • restrictions on 3.10
  • Size of an Integer and ROWID D.1.5
  • SQL
    • benefits of 1.3
    • Embedded SQL 1.3
    • nature of 1.3
    • need for 1.3
  • SQL_CURSOR E.4
  • SQL_SINGLE_RCTX
    • defined constant 5.11
    • definition of 5.9
  • SQL, dynamic 2.1.3
  • SQL*Forms
    • display error screen in 20.8
    • IAP constants in 20.8.1
    • returning values to 20.8
    • reverse return code switch in 20.8
  • SQL*Plus 1.3
    • using to test SELECT statements 6.3.1.1
    • versus embedded SQL 1.3
  • sqlald() function
  • sqlaldt() function
    • see SQLSQLDAAlloc 5.11
  • SQLCA 9.2.2, 9.5
  • sqlca.h
  • SQLCAID component 9.6.3.1
  • SQLCDAFromResultSetCursor() 5.11
  • SQLCDAGetCurrent 5.11
  • sqlcdat()
    • see SQLCDAFromResultSetCursor() 5.11
  • SQLCHECK option
    • restrictions on C.2
    • what it affects C.2
  • SQLCHECK precompiler option 17.8.6, C.3.1.1, C.3.1.2
  • SQLCHECK support for objects 17.8.6
  • sqlclu() function
  • sqlclut() function
    • see SQLSQLDAFree() 5.11
  • sqlcode
    • component in SQLCA 9.5.1
  • SQLCODE
  • SQLCODE status variable
    • declaring 9.4
    • when declared with the SQLCA 9.4
    • when used 9.4
  • SQL Communications Area 9.2.2
  • sqlcpr.h 9.7
  • sqlcurt() function
    • see SQLDAToResultSetCursor() 5.11
  • SQLDA
  • sqlda.h 15.1.3
  • SQLDAToResultSetCursor() 5.11
  • SQL Descriptor Area
  • SQL directives
  • SQLEnvGet() 5.11
  • SQLEnvGet function in SQLLIB 5.9.1
  • sqlerrd
  • sqlerrd[2] component 9.5.3, 9.6.3.6
    • returns N or rows fetched 8.4.3
    • use with data manipulation statements 8.4.2
  • sqlerrmc component 9.6.3.4
  • sqlerrml component 9.6.3.4
  • SQLERROR
    • WHENEVER directive condition E.78
  • SQLERROR condition
  • SQLErrorGetText() 5.11
  • SQLExtProcError() 5.11, 7.8.3
  • sqlglm() 9.7
  • sqlglm() function 9.7
    • example of using 9.7
    • parameters of 9.7
  • sqlglmt()
    • see SQLErrorGetText 5.11
  • sqlgls() function 9.9
    • example of use 4.4.7
    • sample program for 9.9.2
    • see SQLLIB
      • function SQLStmGetText 4.4.7
  • sqlglst() function
    • see SQLStmtGetText 5.11
  • sqlld2t() function
    • see SQLLDAGetName 5.11
  • SQLLDAGetName 5.11
  • sqlldat() function
    • see SQLCDAGetCurrent 5.11
  • SQLLIB
    • and embedded SQL 2.1.2
    • extensions for OCI interoperability 5.8
    • function
      • SQLCDAFromResultSetCursor 5.11
    • function SQLCDAGetCurrent 5.11
    • function SQLColumnNullCheck 5.11
    • function SQLDAFree 5.11
    • function SQLDAToResultSetCursor 5.11
    • function SQLEnvGet 5.9.1, 5.11
    • function SQLErrorGetText 5.11
    • function SQLExtProcError 5.11, 7.8.3
    • function SQLLDAGetName 5.11
    • function SQLNumberPrecV6 5.11
    • function SQLNumberPrecV7 5.11
    • function SQLRowidGet 5.11
    • function SQLStmtGetText() 5.11
    • function SQLSvcCtxGet 5.9.2, 5.11
    • function SQLVarcharGetLength 4.4.6
    • new names for public functions 5.11
  • SQLLIB function
    • SQLSQLDAAlloc 5.11
    • SQLVarcharGetLength 5.11
  • sqlnul() function
  • sqlnult() function
    • see SQLColumnNullCheck() 5.11
  • SQLNumberPrecV6 5.11
  • SQLNumberPrecV7 5.11
  • sqlpr2() function 15.4.2.1
  • sqlpr2t() function
    • see SQLNumberPrecV7 5.11
  • sqlprc() function 15.4.2.1
  • sqlprct() function
    • see SQLNumberPrecV6 5.11
  • SQLRowidGet() 5.11
  • SQLSQLDAAlloc 5.11
  • SQLSQLDAFree() 5.11
  • SQLSTATE
  • SQL statements
  • SQLStmtGetText 5.11
  • SQLStmtGetText() function F.1
  • SQLSvcCtxGet() 5.11
  • SQLSvcCtxGet function in SQLLIB 5.9.2
  • SQLVarcharGetLength 5.11
  • sqlvcp() function F.1
  • sqlvcp() function, see SQLLIB
    • function SQLVarcharGetLength 4.4.6
  • sqlvcpt() function
    • see SQLVarcharGetLength 5.11
  • sqlwarn
  • SQLWARNING
    • WHENEVER directive condition E.78
  • SQLWARNING condition
  • Standard Header Files D.1.1
  • statement-level rollback
  • status codes
  • STOP action
  • stored procedures
  • stored subprograms
  • STRING datatype 4.1.2.5
  • string host variables
  • Struct Component Alignment D.1.4
  • structs
    • array of 8.10
    • as host variables 4.8
    • C, using 17.12
    • for collection object types 18.2
    • generating C structs for a REF 17.13.1
    • pointers as host variables 4.9.3
  • structs (structures)
  • structures (structs)
    • nesting not permitted for host 4.8.3
  • subqueries
  • S variable in SQLDA
  • symbols
  • syntax, embedded SQL 2.1.2
  • syntax checking
    • controlling with the SQLCHECK option C.2
    • definition of C.1
  • syntax diagram
    • description of E.3
    • how to read E.3
    • how to use E.3
    • symbols used in E.3
  • SYS_INCLUDE
    • system header files in C++ 12.2.4
  • SYS_INCLUDE, INCLUDE Precompiler Options 10.2.1
  • SYS_INCLUDE precompiler option 10.5.59
  • system configuration file 10.2.3
  • System Configuration File D.1.10
  • system failure
    • effect on transactions 3.5
  • System Global Area (SGA) 7.7
  • system header files
    • specifying the location of 12.2.4
  • system-specific Oracle documentation 1.8.11, 2.6, 3.2.2, 5.12.1.4, 20
  • system-specific reference 4.1.2.3, 10.1.1, 10.2.2, 10.5.29, 10.5.59

T

U

  • undo a transaction E.71
  • Unicode character set 5.1.5
  • unions
    • cannot be nested in host structures 4.8.3
    • not permitted as host structures 4.8.3
  • universal ROWID 4.1.2.9
  • UNIX
    • linking a Pro*C application under 1.8.11
  • UNSAFE_NULL precompiler option 10.5.62
  • UNSIGNED datatype 4.1.2.14
  • UPDATE SQL statement E.76
  • UPDATE statement
  • updating
    • rows in tables and views E.76
  • use
  • user configuration file
    • to set precompiler options 10.2.3
  • user-defined record 7.1.7
  • user-defined stored function
    • used in WHERE clause 6.3.5
  • user-defined type equivalencing E.75
  • user exits
    • calling from a SQL*Forms trigger 20.6
    • common uses for 20.2
    • example of 20.9
    • kinds of statements allowed in 20.4
    • linking into IAP 20.13
    • meaning of codes returned by 20.8
    • naming 20.14.1
    • passing parameters to 20.7
    • requirements for variables in 20.4.1
    • running the GENXTB form 20.12
    • running the GENXTB utility for 20.12
    • use of WHENEVER statement in 20.8.2
  • User Exits D.1.13
  • USERID option
  • USERID OTT parameter 19.5.2.1
  • USERID precompiler option 10.5.63
    • using with the SQLCHECK option C.3.1.1
  • usernames
  • user session
    • definition of 3.3
  • USING clause
  • using collection types 17.13
  • using C structures 17.12
  • using dbstring
    • Oracle Net database specification string E.16
  • Using REFs in Embedded SQL 17.13.3

V

W

  • warning flags
    • use in error reporting 9.5.2
  • WHENEVER directive
  • WHENEVER SQL directive E.78
  • WHENEVER statement
  • WHERE clause
  • WHERE CURRENT OF clause
    • CURRENT OF clause 6.9
  • WITH HOLD
    • clause of DECLARE CURSOR statement 6.5.1
  • WORK option
    • of COMMIT statement E.15
    • of ROLLBACK statement E.71

X

Y

Z