Pro*C/C++ Programmer's Guide
ContentsOpens a new window
Opens a new window
Page 35 of 35

Index

AOpens a new window  BOpens a new window  COpens a new window  DOpens a new window  EOpens a new window  FOpens a new window  GOpens a new window  HOpens a new window  IOpens a new window  JOpens a new window  LOpens a new window  MOpens a new window  NOpens a new window  OOpens a new window  POpens a new window  QOpens a new window  ROpens a new window  SOpens a new window  TOpens a new window  UOpens a new window  VOpens a new window  WOpens a new window  XOpens a new window  YOpens a new window  ZOpens a new window 

Symbols

#include
file inclusion, Pro*C compared to C, 5.4.1Opens a new window

A

ABOpens a new window  ACOpens a new window  ALOpens a new window  ANOpens a new window  APOpens a new window  AROpens a new window  ASOpens a new window  ATOpens a new window  AUOpens a new window 
abnormal termination
automatic rollback, E.15Opens a new window
active set
changing, 6.5.2Opens a new window, 6.5.3Opens a new window
cursor movement through, 6.5.3Opens a new window
definition of, 2.1.9Opens a new window
how identified, 6.5Opens a new window
if empty, 6.5.3Opens a new window
when fetched from, 6.5.3Opens a new window
when no longer defined, 6.5Opens a new window
ALLOCATE
allocating a cursor variable, 4.5.2Opens a new window
ALLOCATE DESCRIPTOR statement, 14.5.1Opens a new window, E.5Opens a new window
ALLOCATE SQL statement, 17.4.2Opens a new window
ALLOCATE SQL statements, E.4Opens a new window
allocating
cursor variables, 4.5.2Opens a new window
cursors, E.4Opens a new window
thread context, 11.4.2.2Opens a new window, E.17Opens a new window
ANSI C Support, D.1.3Opens a new window
ANSI dynamic SQL, F.1Opens a new window
reference semantics, 14.3.1Opens a new window
See also dynamic SQL (ANSI), 14Opens a new window
application development process, 2.2Opens a new window
array of structs, 8.10Opens a new window
ARRAYLEN statement, 7.5.1Opens a new window
arrays
batch fetch, 8.4.1Opens a new window
bulk operations (ANSI dynamic SQL), 14.3.2Opens a new window
chapter discusses how to use, 8Opens a new window
definition of, 4.8.1Opens a new window
host arrays, 2.1.7Opens a new window
operations, 2.1.7Opens a new window
varying length, 18.1.2Opens a new window
associative interface, 17.4Opens a new window
when to use, 17.4.1Opens a new window
AT clause
in CONNECT statement, 3.2.4.1Opens a new window
in DECLARE CURSOR statement, 3.2.4.1.3Opens a new window
in DECLARE STATEMENT statement, 3.2.4.1.4Opens a new window
in EXECUTE IMMEDIATE statement, 3.2.4.1.4Opens a new window
of COMMIT statement, E.15Opens a new window
of DECLARE CURSOR directive, E.23Opens a new window
of EXECUTE IMMEDIATE statement, E.35Opens a new window
of EXECUTE statement, E.32Opens a new window
of INSERT statement, E.40Opens a new window
of SAVEPOINT statement, E.72Opens a new window
of SELECT statement, E.73Opens a new window
of SROLLBACK statement, E.71Opens a new window
of UPDATE statement, E.76Opens a new window
restriction on, 3.2.4.1.3Opens a new window
use of, 3.2.4.1.3Opens a new window
attributes of a collection
descriptions, 18.4.6Opens a new window
AUTO_CONNECT, 10.5.1Opens a new window
precompiler option, 3.1.3.1Opens a new window
AUTO_CONNECT precompiler option, 10.5.1Opens a new window
automatic connections, 3.1.3Opens a new window, 3.2.4Opens a new window

B

BAOpens a new window  BFOpens a new window  BIOpens a new window  BROpens a new window  BYOpens a new window 
batch fetch
advantage of, 8.4.1Opens a new window
example of, 8.4.1Opens a new window
number of rows returned by, 8.4.3Opens a new window
BFILES, 16.1.2Opens a new window
security, 16.1.3Opens a new window
bind descriptor, 13.10.1Opens a new window, 15.2.1Opens a new window, 15.2.1Opens a new window
definition of, 13.10.1Opens a new window
information in, 13.10.2Opens a new window
bind SQLDA
purpose of, 15.1.3Opens a new window
bind variables
input host variables, 13.10.1Opens a new window
binding
definition of, 13.5Opens a new window
BREAK action
of WHENEVER, E.78Opens a new window
Byte Ordering, D.1.6Opens a new window

C

CAOpens a new window  CHOpens a new window  CLOpens a new window  COOpens a new window  CPOpens a new window  CROpens a new window  CUOpens a new window 
C preprocessor
directives supported by Pro*C, 5.4Opens a new window
how used in Pro*C, 5.4Opens a new window
C structs
generating for a REF, 17.13.1Opens a new window
using, 17.12Opens a new window
C types of collection attributes, 18.4.6Opens a new window
C variable in SQLDA
how value is set, 15.3.9Opens a new window
purpose of, 15.3.9Opens a new window
C++, 1.8.5Opens a new window
C++ applications, 12Opens a new window
cache, 17.3Opens a new window
CACHE FREE ALL SQL statement, 17.4.4Opens a new window
CACHE FREE ALL statement, E.6Opens a new window
CALL SQL statement, E.7Opens a new window
CALL statement, 7.7.2.3Opens a new window
example, 7.7.2.4Opens a new window
CASE OTT parameter, 19.5.2.10Opens a new window
case sensitivity
in precompiler options, 10.1.1Opens a new window
CHAR datatype, 4.1.2.17Opens a new window
CHAR_MAP precompiler option, 5.1.1Opens a new window, 10.5.2Opens a new window
character data, 5.1Opens a new window
character strings
multibyte, 4.11.4Opens a new window
CHARF datatype, 4.1.2.19Opens a new window, 5.3.3Opens a new window
CHARZ datatype, 4.1.2.18Opens a new window
CLOSE CURSOR statement, 14.5.13Opens a new window
CLOSE SQL statements, E.8Opens a new window
CLOSE statement
dependence on precompiler options, 6.5.4Opens a new window
example, 6.5.4Opens a new window, E.8Opens a new window
purpose of, 6.5Opens a new window, 6.5.4Opens a new window
use in dynamic SQL method 4, 15.6.18Opens a new window
CLOSE_ON_COMMIT
precompiler option, 3.6.2Opens a new window, 6.5.1Opens a new window, 10.5.4Opens a new window
CLOSE_ON_COMMIT precompiler option, 10.5.4Opens a new window
closing
cursors, E.8Opens a new window
CODE
precompiler option, 12.2.1Opens a new window
CODE option, 10.2.7.2Opens a new window
CODE OTT parameter, 19.5.2.4Opens a new window
code page, 4.10Opens a new window
CODE precompiler option, 10.5.8Opens a new window, 10.5.8Opens a new window
coding conventions, 2.3Opens a new window
COLLECT GET statement
example, 18.5.2Opens a new window
COLLECTION APPEND, E.9Opens a new window
COLLECTION APPEND statement, 18.4.4Opens a new window
SQL statements
COLLECTION APPEND, E.9Opens a new window
COLLECTION DESCRIBE
example, 18.5.3Opens a new window
COLLECTION DESCRIBE statement, 18.4.6Opens a new window
SQL statements
COLLECTION DESCRIBE, E.10Opens a new window
COLLECTION GET statement, 18.4.1Opens a new window
SQL statements
COLLECTION GET, E.11Opens a new window
collection object types
handling, 18.2.2Opens a new window
COLLECTION RESET statement, 18.4.3Opens a new window
example, 18.5.4Opens a new window
SQL statements
COLLECTION RESET, E.12Opens a new window
COLLECTION SET statement, 18.4.2Opens a new window
example, 18.5.2Opens a new window
SQL statements
COLLECTION SET, E.13Opens a new window
COLLECTION TRIM statement, 18.4.5Opens a new window
SQL statements
COLLECTION TRIM, E.14Opens a new window
collection types
structs for, 18.2Opens a new window
collections
and C, 18.1.3Opens a new window
autonomous access, 18.2.2.1Opens a new window
descriptors, 18.2Opens a new window
element access, 18.2.2.2Opens a new window
manipulating, 18.2.2Opens a new window
nested tables, 18.1.1Opens a new window
OBJECT GET statement, 18.3Opens a new window
OBJECT SET statement, 18.3Opens a new window
VARRAYs, 18.1.2Opens a new window
column list
in INSERT statements, 6.3.2Opens a new window
when permissible to omit, 6.3.2Opens a new window
COMMENT clause
of COMMIT statement, E.15Opens a new window
comments
ANSI, 2.3.1Opens a new window
which allowed, 2.3.1Opens a new window
Comments
restrictions in PL/SQL block, 13.12.4Opens a new window
commit
automatic, 3.5Opens a new window
explicit versus implicit, 3.5Opens a new window
function of, 3.4Opens a new window
COMMIT
signal handler single thread limitation, 9.2Opens a new window
COMMIT SQL statement, E.15Opens a new window
COMMIT statement, 3.6Opens a new window
effect of, 3.6Opens a new window
ending a transaction, E.71Opens a new window
example of, 3.6Opens a new window
examples, E.15Opens a new window
purpose of, 3.6Opens a new window
RELEASE option in, 3.6Opens a new window
using in a PL/SQL block, 3.14.3Opens a new window
where to place, 3.6Opens a new window
committing
transactions, E.15Opens a new window
communicating over a network, 3.2.1Opens a new window
COMP_CHARSET precompiler option, 10.5.9Opens a new window, 10.5.10Opens a new window, 10.5.10Opens a new window
compiling, 2.6Opens a new window
specifying include file locations, 5.4.7Opens a new window
concurrency
definition of, 3.3Opens a new window
concurrent connections, 3.2.2Opens a new window
conditional precompilation, 2.4Opens a new window
defining symbols, 5.6.1Opens a new window
example, 2.4.2Opens a new window, 5.6.2Opens a new window
CONFIG OTT parameter, 19.5.2.8Opens a new window
CONFIG precompiler option, 10.5.3Opens a new window, 10.5.5Opens a new window, 10.5.6Opens a new window, 10.5.7Opens a new window, 10.5.11Opens a new window, 10.5.11Opens a new window, 10.5.12Opens a new window, 10.5.14Opens a new window
configuration files, 10.2.2Opens a new window, 10.2.7.1Opens a new window
and the Object Type Translator, 19.2.2Opens a new window
location, 10.2.2Opens a new window, 10.2.7.1Opens a new window
system, 10.2.3Opens a new window
user, 10.2.3Opens a new window
CONNECT statement, E.16Opens a new window, E.16Opens a new window
AT clause in, 3.2.4.1Opens a new window
connecting to Oracle with, 3.1Opens a new window
examples, E.16Opens a new window
requirements for, 3.1Opens a new window
USING clause in, 3.2.4.1Opens a new window
using to enable a semantic check, C.3.1.1Opens a new window
connecting to Oracle, 3.1Opens a new window
automatic connections, 3.1.3Opens a new window
concurrently, 3.2.2Opens a new window
example of, 3.1Opens a new window
using Oracle Net, 3.2.2Opens a new window
connection pooling, 11.6Opens a new window
demo program1, 11.6.2Opens a new window
demo program2, 11.6.3Opens a new window
example, 11.6.3.3Opens a new window
using, 11.6.1Opens a new window
connections
concurrent, 3.2.4.2Opens a new window
default versus nondefault, 3.2.3Opens a new window
Explicit connections, 3.2.4Opens a new window
implicit, 3.2.5Opens a new window
naming of, 3.2.4Opens a new window
const
declaring constants, 5.7.2Opens a new window
CONTEXT ALLOCATE SQL statement, E.17Opens a new window
CONTEXT ALLOCATE statement, 11.4.2.2Opens a new window
context block
definition of, 20.4.1Opens a new window
CONTEXT FREE statement, 11.4.2.4Opens a new window, E.18Opens a new window
CONTEXT OBJECT OPTION GET SQL statement, 17.7.2Opens a new window
CONTEXT OBJECT OPTION SET SQL statement, 17.7.1Opens a new window
CONTEXT USE directive, 11.4.2.3Opens a new window
CONTEXT USE SQL directive, E.21Opens a new window
CONTEXT USE SQL statement, 11.4.2.3Opens a new window
CONTINUE action
in the WHENEVER statement, 9.9.2.1Opens a new window
of WHENEVER directive, E.78Opens a new window, E.78Opens a new window
result of, 9.9.2.1Opens a new window
CONVBUFSZ clause, 4.11.3Opens a new window
CPP_SUFFIX
precompiler option, 12.2.3Opens a new window
CPP_SUFFIX precompiler option, 10.5.13Opens a new window
CPP_SUFFIX precompiler options, 10.5.13Opens a new window
CREATE PROCEDURE statement
embedded, 7.7.1Opens a new window
creating
savepoints, E.72Opens a new window
creating temporary LOB, 16.4.5Opens a new window
CURRENT OF clause, 8.3.3Opens a new window
example of, 6.9Opens a new window
mimicking with ROWID, 3.12Opens a new window, 8.11Opens a new window
purpose of, 6.9Opens a new window
restrictions on, 6.9.1Opens a new window
current row
definition of, 2.1.9Opens a new window
using FETCH to retrieve, 6.5Opens a new window
cursor cache
definition of, 9.11.4Opens a new window
purpose of, B.9.2.1Opens a new window
cursor control statements
example of typical sequence, 6.10Opens a new window
cursor operations
overview of, 6.5Opens a new window
cursor variables, 4.5Opens a new window, E.4Opens a new window
allocating, 4.5.2Opens a new window
declaring, 4.5.1Opens a new window
restrictions on, 4.5.6Opens a new window
cursors, 2.5.1.1Opens a new window, 4.5Opens a new window
allocating, E.4Opens a new window
allocating a cursor variable, 4.5.2Opens a new window
analogy for, 2.1.9Opens a new window
association with queries, 6.5Opens a new window
closing, E.8Opens a new window
declaring, 6.5.1Opens a new window
definition of, 2.1.9Opens a new window
explicit versus implicit, 2.1.9Opens a new window
fetching rows from, E.36Opens a new window, E.37Opens a new window
for multirow queries, 6.5Opens a new window
how handling affects performance, B.9.1Opens a new window
movement through active set, 6.5.3Opens a new window
opening, E.67Opens a new window, E.68Opens a new window
purpose of, 6.5Opens a new window
reopening, 6.5.2Opens a new window, 6.5.3Opens a new window
restrictions on declaring, 6.5.1Opens a new window
rules for naming, 6.5.1Opens a new window
scope of, 6.5.1Opens a new window
scrollable cursors, 6.6Opens a new window
statements for manipulating, 6.5Opens a new window
types of, 2.1.9Opens a new window
using more than one, 6.5.1Opens a new window

D

DAOpens a new window  DBOpens a new window  DEOpens a new window  DIOpens a new window  DMOpens a new window  DOOpens a new window  DTOpens a new window  DUOpens a new window  DYOpens a new window 
data definition language
in transactions, 3.5Opens a new window
data integrity, 3.2.4.3Opens a new window
definition of, 3.3Opens a new window
data locks, 3.3Opens a new window
database link
creating synonym for, 3.2.5.1Opens a new window
defining, 3.2.5.1Opens a new window
example using, 3.2.5.1Opens a new window
using in INSERT statement, E.40Opens a new window
where stored, 3.2.5.1Opens a new window
database types
new, 17.15Opens a new window
databases
naming, 3.2.3Opens a new window
datatype equivalencing, 2.1.8Opens a new window
datatypes
ANSI DATE, 4.1.3.2Opens a new window
codes used in descriptors, 15.4.2Opens a new window
coercing NUMBER to VARCHAR2, 15.4.2Opens a new window
conversions, 5.2Opens a new window, 5.2Opens a new window
dealing with ORACLE internal, 15.4.2Opens a new window
equivalencing, 5.3Opens a new window
equivalencing, purpose of, 2.1.8Opens a new window
internal, 4.1.1Opens a new window
internal versus external, 2.1.6Opens a new window
INTERVAL DAY TO SECOND, 4.1.3.7Opens a new window
INTERVAL YEAR TO MONTH, 4.1.3.6Opens a new window
list of internal, 15.4.1.1Opens a new window
need to coerce, 15.4.2Opens a new window
Oracle, 2.1.6Opens a new window
OTT mappings, 19.2.5Opens a new window
restrictions on using, 17.16Opens a new window
TIMESTAMP, 4.1.3.3Opens a new window
TIMESTAMP WITH LOCAL TIME ZONE, 4.1.3.5Opens a new window
TIMESTAMP WITH TIME ZONE, 4.1.3.4Opens a new window
user-defined type equivalencing, E.75Opens a new window
when to reset, 15.4.2Opens a new window
DATE datatype, 4.1.2.10Opens a new window
DATE, ANSI
datatype, 4.1.3.2Opens a new window
datetime
avoiding unexpected results, 4.1.3.8Opens a new window
DBMS interaction with MODE, 10.5.16Opens a new window
DBMS option, 5.3.3Opens a new window, 10.2.7.3Opens a new window
DBMS precompiler option, 10.5.15Opens a new window, 10.5.16Opens a new window, 10.5.16Opens a new window
deadlock
definition of, 3.3Opens a new window
effect on transactions, 3.8.1Opens a new window
how broken, 3.8.1Opens a new window
DEALLOCATE DESCRIPTOR statement, 14.5.2Opens a new window, E.22Opens a new window
declaration
of cursors, 6.5.1Opens a new window
of host arrays, 8.2Opens a new window
of pointer variables, 4.9.1Opens a new window
of SQLCA, 9.7.1Opens a new window
declarative SQL statements
in transactions, 3.5Opens a new window
DECLARE CURSOR directives
examples, E.23Opens a new window
DECLARE CURSOR statement, 14.5.10Opens a new window
AT clause in, 3.2.4.1.3Opens a new window
use in dynamic SQL method 4, 15.6.7Opens a new window
DECLARE DATABASE SQL directives, E.24Opens a new window
Declare Section
allowable statements, 2.3.3Opens a new window
form, 2.3.3Opens a new window
purpose, 2.3.3Opens a new window
required when MODE=ANSI, 10.5.37Opens a new window
requirements, 2.3.3Opens a new window
rules for defining, 2.3.3Opens a new window
when MODE=ANSI, 5.3.4Opens a new window
when required, 2.3.3Opens a new window, 4.2.1Opens a new window
DECLARE statement, 6.5.1Opens a new window
example of, 6.5.1Opens a new window
purpose of, 6.5Opens a new window
required placement of, 6.5.1Opens a new window
scope of, E.25Opens a new window
use in dynamic SQL method 3, 13.9.2Opens a new window
DECLARE STATEMENT directive, E.25Opens a new window
DECLARE STATEMENT statement
AT clause in, 3.2.4.1.4Opens a new window
example of using, 13.11Opens a new window
using with dynamic SQL, 13.11Opens a new window
when required, 13.11Opens a new window
DECLARE statements
examples, E.25Opens a new window
DECLARE TABLE directive
examples, E.26Opens a new window
using with the SQLCHECK option, C.3.1.2Opens a new window
DECLARE TABLE SQL directive, E.26Opens a new window
DECLARE TABLE statement
need for with AT clause, 3.2.4.1.1Opens a new window
DECLARE TYPE directive, E.27Opens a new window
DEF_SQLCODE precompiler option, 10.5.17Opens a new window
default connections, 3.2.3Opens a new window
default database, 3.2.3Opens a new window
default file name extensions, 19.5.7Opens a new window
DEFINE precompiler option, 10.5.18Opens a new window
used in application migration, 5.4.9Opens a new window
defining symbols, 2.4.1Opens a new window
DELETE SQL statement, E.28Opens a new window
DELETE statement
embedded SQL examples, E.28Opens a new window
example of, 6.3.4Opens a new window
purpose of, 6.3.4Opens a new window
using host arrays in, 8.7Opens a new window
WHERE clause in, 6.3.4Opens a new window
delimiters
C versus SQL, 2.3.4Opens a new window
DEPT table, 2.7Opens a new window
DESCRIBE BIND VARIABLES statement
use in dynamic SQL method 4, 15.6.8Opens a new window
DESCRIBE command
use with PREPARE command, E.29Opens a new window
DESCRIBE DESCRIPTOR statement, E.30Opens a new window
DESCRIBE INPUT statement, 14.5.6Opens a new window
DESCRIBE OUTPUT statement, 14.5.7Opens a new window
DESCRIBE SELECT LIST statement
use in dynamic SQL method 4, 15.6.12Opens a new window
DESCRIBE SQL statement, E.29Opens a new window
DESCRIBE statement
examples, E.29Opens a new window
use in dynamic SQL Method 4, 13.10.1Opens a new window
descriptions of collection attributes, 18.4.6Opens a new window
descriptors, 15.2.1Opens a new window
bind descriptor, 13.10.1Opens a new window
definition of, 13.10Opens a new window
need for, 15.2.1Opens a new window
select descriptor, 13.10.1Opens a new window
using the sqlald() function to allocate, 15.2.4Opens a new window
using the sqlclu() function to deallocate, 15.6.17Opens a new window
determining current value of precompiler options, 10.2.3Opens a new window
directory structures, 1.6Opens a new window
distributed processing
support for, 3.2.2Opens a new window
using Oracle Net for, 3.2.2Opens a new window
distributed transactions, E.71Opens a new window
DML returning clauses, 6.4Opens a new window
DO action
in the WHENEVER statement, 9.9.2.2Opens a new window
of WHENEVER directive, E.78Opens a new window
result of, 9.9.2.2Opens a new window
.dsp files, F.4Opens a new window
DTP model, 5.12Opens a new window
dummy host variables
placeholders, 13.4Opens a new window
DURATION precompiler option, 10.5.20Opens a new window, 17.8.2Opens a new window
Dynamic Link Libraries (DLLs), 1.7Opens a new window
dynamic PL/SQL
rules for, 13.12Opens a new window
versus dynamic SQL, 13.12Opens a new window
dynamic SQL
advantages and disadvantages of, 13.2Opens a new window
cannot use cursor variables with, 4.5.6Opens a new window
choosing the right method, 13.6.5Opens a new window
definition of, 2.1.3Opens a new window
guidelines for, 13.6.5Opens a new window
method 1, F.1Opens a new window
method 2, F.1Opens a new window
method 3, F.1Opens a new window, F.1Opens a new window
method 4, F.1Opens a new window
overview of, 13.1Opens a new window
restriction on, 6.9.1Opens a new window
restrictions on use of datatypes, 17.16Opens a new window
restrictions on using datatypes in, 17.16Opens a new window
use of PL/SQL with, 7.9Opens a new window
uses for, 13.2Opens a new window
using the AT clause in, 3.2.4.1.4Opens a new window
when to use, 13.3Opens a new window
dynamic SQL (ANSI)
basics, 14.1Opens a new window
bulk operations, 14.3.2Opens a new window
differences from Oracle dynamic, 14.5.14Opens a new window
Oracle extensions, 14.3Opens a new window
Overview, 14.2Opens a new window
precompiler options, 14.4Opens a new window
Precompiler Options, 14.1.1Opens a new window
reference semantics, 14.3.1Opens a new window
sample program, 14.6.2Opens a new window
sample programs, 14.6Opens a new window
dynamic SQL method 1
commands used with, 13.6.1Opens a new window
description of, 13.7Opens a new window
example of, 13.7.1Opens a new window
how to use, 13.7Opens a new window
requirements for, 13.6.1Opens a new window
use of EXECUTE IMMEDIATE with, 13.7Opens a new window
use of PL/SQL with, 13.12.1Opens a new window
dynamic SQL method 2
commands used with, 13.6.2Opens a new window
description of, 13.8Opens a new window
example of, 13.8.2Opens a new window
requirements for, 13.6.2Opens a new window
use of DECLARE STATEMENT with, 13.11Opens a new window
use of EXECUTE with, 13.8Opens a new window
use of PL/SQL with, 13.12.2Opens a new window
use of PREPARE with, 13.8Opens a new window
dynamic SQL method 3
commands used with, 13.6.3Opens a new window
compared to method 2, 13.9Opens a new window
example program, 13.9.6Opens a new window
requirements for, 13.6.3Opens a new window
sequence of statements used with, 13.9Opens a new window
use of DECLARE STATEMENT with, 13.11Opens a new window
use of DECLARE with, 13.9.2Opens a new window
use of FETCH with, 13.9.4Opens a new window
use of OPEN with, 13.9.3Opens a new window
use of PL/SQL with, 13.12.3Opens a new window
use of PREPARE with, 13.9.1Opens a new window
dynamic SQL method 4
need for descriptors with, 15.2.1Opens a new window
overview of, 13.10.1Opens a new window
prerequisites for using, 15.4Opens a new window
requirements for, 13.6.4Opens a new window
requirements of, 15.1.1Opens a new window
sample program, 15.7Opens a new window
sequence of statements used with, 13.10.4Opens a new window, 15.6Opens a new window
steps for, 15.5Opens a new window
use of CLOSE statement in, 15.6.18Opens a new window
use of DECLARE CURSOR statement in, 15.6.7Opens a new window
use of DECLARE STATEMENT with, 13.11Opens a new window
use of DESCR, 13.10.1Opens a new window
use of DESCRIBE statement in, 15.6.8Opens a new window, 15.6.12Opens a new window
use of descriptors with, 13.10Opens a new window
use of FETCH statement in, 15.6.15Opens a new window
use of OPEN statement in, 15.6.11Opens a new window
use of PL/SQL with, 13.12.4Opens a new window
use of PREPARE statement in, 15.6.6Opens a new window
use of the SQLDA in, 13.10.1Opens a new window, 15.2.1Opens a new window
using host arrays with, 15.6.19Opens a new window
using the FOR clause with, 13.11.1Opens a new window, 15.6.19Opens a new window
when needed, 13.10Opens a new window
dynamic SQL methods
overview of, 13.6Opens a new window
dynamic SQL statements
binding of host variables in, 13.5Opens a new window
definition of, 13.1Opens a new window
requirements for, 13.4Opens a new window
use of placeholders in, 13.4Opens a new window
using host arrays in, 13.11.1Opens a new window
versus static SQL statements, 13.1Opens a new window

E

EMOpens a new window  ENOpens a new window  EQOpens a new window  EROpens a new window  EXOpens a new window 
embedded PL/SQL
advantages of, 7.1.1Opens a new window
cursor FOR loop, 7.1.3Opens a new window
example of, 7.3.1Opens a new window, 7.3.2Opens a new window
overview of, 2.1.4Opens a new window
packages, 7.1.5Opens a new window
PL/SQL tables, 7.1.6Opens a new window
procedures and functions, 7.1.4Opens a new window
requirements for, 7.2Opens a new window
SQLCHECK option, 7.2Opens a new window
support for SQL, 2.1.4Opens a new window
user-defined records, 7.1.7Opens a new window
using %TYPE, 7.1.2Opens a new window
using the VARCHAR pseudotype with, 7.3.3Opens a new window
using to improve performance, B.4Opens a new window
where allowed, 7.2Opens a new window
embedded SQL, F.1Opens a new window
ALLOCATE statement, E.4Opens a new window
CLOSE statement, E.8Opens a new window
CONTEXT ALLOCATE statement, 11.4.2.2Opens a new window, E.17Opens a new window
CONTEXT FREE statement, 11.4.2.4Opens a new window
definition of, 2.1.1Opens a new window
difference from interactive SQL, 2.1.2Opens a new window
ENABLE THREADS statement, 11.4.2.1Opens a new window
EXEC SQL CACHE FREE ALL, 17.4.4Opens a new window
EXECUTE statement, E.32Opens a new window
key concepts of, 2.1Opens a new window
mixing with host-language statements, 2.1.2Opens a new window
OPEN statement, E.67Opens a new window
overview of, 2.1.1Opens a new window
PREPARE statement, E.69Opens a new window
requirements for, 2.1.2Opens a new window
SAVEPOINT statement, E.72Opens a new window
SELECT statement, E.73Opens a new window
syntax for, 2.1.2Opens a new window
testing with SQL*Plus, 1.3Opens a new window
TYPE directive, E.75Opens a new window
UPDATE statement, E.76Opens a new window
using OCI types in, 17.14.2Opens a new window
using REFs in, 17.13.3Opens a new window
VAR directive, E.77Opens a new window
when to use, 1.3Opens a new window
WHENEVER directive, E.78Opens a new window
embedded SQL statements
labels for, 9.9.2.5Opens a new window
referencing host arrays in, 8.3.1Opens a new window
referencing host variables in, 4.2.2Opens a new window
suffixes and prefixes not allowed, 2.3.2Opens a new window
terminator for, 2.3.13Opens a new window
use of apostrophes in, 2.3.4Opens a new window
use of quotation marks in, 2.3.4Opens a new window
embedding
PL/SQL blocks in precompiler programs, E.32Opens a new window
EMP table, 2.7Opens a new window
ENABLE THREADS SQL statement, E.31Opens a new window
ENABLE THREADS statement, 11.4.2.1Opens a new window
enabling
threads, 11.4.2.1Opens a new window
encoding scheme (character set or code page), 4.10Opens a new window
enqueues
locking, 3.3Opens a new window
entering options, 5.4.4Opens a new window, 10.4Opens a new window
environment variables, 10.2.1Opens a new window
equivalencing
host variable equivalencing, E.77Opens a new window
user-defined type equivalencing, E.75Opens a new window
equivalencing of datatypes
datatype equivalencing, 2.1.8Opens a new window
error detection
error reporting, E.78Opens a new window
error handling, 2.1.11Opens a new window
alternatives, 9.3Opens a new window
need for, 9.1Opens a new window
overview of, 2.1.11Opens a new window
SQLCA versus WHENEVER statement, 9.3.2Opens a new window
use of ROLLBACK statement in, 3.8Opens a new window
error messages
maximum length of, 9.8Opens a new window
use in error reporting, 9.6.5Opens a new window
using the sqlglm() function to get, 9.8Opens a new window
where available in SQLCA, 9.6.5Opens a new window
error reporting
key components of, 9.6Opens a new window
use of error messages in, 9.6.5Opens a new window
use of parse error offset in, 9.6.4Opens a new window
use of rows-processed count in, 9.6.3Opens a new window
use of warning flags in, 9.6.2Opens a new window
WHENEVER directive, E.78Opens a new window
ERRORS precompiler option, 10.5.21Opens a new window
ERRTYPE
precompiler option, 10.5.22Opens a new window
ERRTYPE OTT parameter, 19.5.2.9Opens a new window
ERRTYPE precompiler option, 17.8.5Opens a new window
exception, PL/SQL
definition of, 7.4.1Opens a new window
EXEC ORACLE DEFINE statement, 5.6Opens a new window
EXEC ORACLE ELSE statement, 2.4Opens a new window, 5.6Opens a new window
EXEC ORACLE ENDIF statement, 2.4Opens a new window, 5.6Opens a new window
EXEC ORACLE IFDEF statement, 2.4Opens a new window, 5.6Opens a new window
EXEC ORACLE IFNDEF statement, 2.4Opens a new window, 5.6Opens a new window
EXEC ORACLE OPTION statement
set option values inline, 10.4Opens a new window
EXEC ORACLE statement
scope of, 10.4.2.2Opens a new window
syntax for, 10.4.2Opens a new window
uses for, 10.4.2.1Opens a new window
EXEC ORACLE statements, 2.4Opens a new window
EXEC SQL CACHE FREE statement, 17.4.4Opens a new window
EXEC SQL clause
using to embed SQL, 2.1.2Opens a new window
EXEC SQL INCLUDE
contrasted with #include, 5.4.8Opens a new window
EXEC SQL VAR statement
CONVBUFSZ clause, 4.11.3Opens a new window
EXEC TOOLS
GET CONTEXT statement, 20.5.5Opens a new window
GET statement, 20.5.3Opens a new window
MESSAGE statement, 20.5.6Opens a new window
SET CONTEXT statement, 20.5.4Opens a new window
SET statement, 20.5.2Opens a new window
EXEC TOOLS statements, 20.5Opens a new window
executable SQL statements
purpose of, 6.3Opens a new window
uses for, 2.1.1.1Opens a new window
where allowed, 2.1.1.1Opens a new window
EXECUTE ... END-EXEC SQL statement, E.32Opens a new window
EXECUTE DESCRIPTOR statement
SQL statements
EXECUTE DESCRIPTOR, E.34Opens a new window
EXECUTE IMMEDIATE SQL statement, E.35Opens a new window
EXECUTE IMMEDIATE statement, 14.5.9Opens a new window
AT clause in, 3.2.4.1.4Opens a new window
examples, E.35Opens a new window
use in dynamic SQL method 1, 13.7Opens a new window
EXECUTE optional keyword of ARRAYLEN statement, 7.5.2Opens a new window
EXECUTE SQL statement, E.33Opens a new window
EXECUTE statement, 14.5.8Opens a new window
examples, E.32Opens a new window, E.33Opens a new window
use in dynamic SQL method 2, 13.8Opens a new window
execution of statements, 13.5Opens a new window
execution plan, B.5Opens a new window, B.5.2Opens a new window
EXPLAIN PLAN statement
function of, B.5.2Opens a new window
using to improve performance, B.5.2Opens a new window
explicit connections, 3.2.4Opens a new window
description of, 3.2.4Opens a new window
multiple, 3.2.4.2Opens a new window
single, 3.2.4.1Opens a new window
extensions
default file name, 19.5.7Opens a new window
external datatypes
definition of, 2.1.6Opens a new window
FLOAT, 4.1.2.4Opens a new window
INTEGER, 4.1.2.3Opens a new window
STRING, 4.1.2.5Opens a new window
external procedures
callbacks, 7.8Opens a new window
calling from PL/SQL, 7.8Opens a new window
creating, 7.8.2Opens a new window
error-handling, 7.8.3Opens a new window
restrictions, 7.8.1Opens a new window

F

FAOpens a new window  FEOpens a new window  FIOpens a new window  FLOpens a new window  FOOpens a new window  FROpens a new window  FUOpens a new window 
F variable in SQLDA
how value is set, 15.3.6Opens a new window
purpose of, 15.3.6Opens a new window
FAQs, 1.8Opens a new window
FETCH DESCRIPTOR SQL statement, E.37Opens a new window
FETCH SQL statement, E.36Opens a new window
FETCH statement, 14.5.12Opens a new window
example of, 6.5.3Opens a new window
examples, E.36Opens a new window
INTO clause in, 6.5.3Opens a new window
purpose of, 6.5Opens a new window, 6.5.3Opens a new window
results of, 6.5.3Opens a new window
use in dynamic SQL method 3, 13.9.4Opens a new window
use in dynamic SQL method 4, 15.6.15Opens a new window
used after OPEN command, E.68Opens a new window
used after OPEN statement, E.67Opens a new window
fetching
rows from cursors, E.36Opens a new window, E.37Opens a new window
fetching in batches
batch fetch, 8.4.1Opens a new window
FIPS flagger
warns of array usage, 8.3.4Opens a new window
warns of missing Declare Section, 4.2.1Opens a new window
warns of use of pointers as host variables, 5.1.3.3Opens a new window
FIPS precompiler option, 10.5.24Opens a new window
flags
warning flags, 9.6.2Opens a new window
FLOAT datatype, 4.1.2.4Opens a new window
FOR clause
example of using, 8.8Opens a new window
of embedded SQL EXECUTE DESCRIPTOR statement, E.34Opens a new window, E.34Opens a new window
of embedded SQL EXECUTE statement, E.33Opens a new window, E.33Opens a new window
purpose of, 8.8Opens a new window
requirements for, 8.8Opens a new window
restrictions on, 8.8.1Opens a new window
using in dynamic SQL method 4, 15.6.19Opens a new window
using with host arrays, 8.8Opens a new window
when variable negative or zero, 8.8Opens a new window
FOR UPDATE OF clause
locking rows with, 3.11Opens a new window
purpose of, 3.11.1Opens a new window
when to use, 3.11Opens a new window
FORCE clause
of COMMIT statement, E.15Opens a new window
of ROLLBACK statement, E.71Opens a new window
forward references
why not allowed, 6.5.1Opens a new window
FREE SQL statement, 17.4.3Opens a new window, E.38Opens a new window
free() function, 15.6.17Opens a new window
example of using, 15.6.17Opens a new window
freeing
thread context, 11.4.2.4Opens a new window, E.18Opens a new window
Frequently Asked Questions, 1.8Opens a new window
full scan
description of, B.7Opens a new window
function prototype
definition of, 10.5.8Opens a new window
functions
cannot serve as host variables, 4.2.2.1Opens a new window

G

GEOpens a new window  GLOpens a new window  GOOpens a new window  GUOpens a new window 
generic documentation references
default values for options, 10.2.7Opens a new window
demo directory, 1.6Opens a new window
header files, location of, 5.5.4Opens a new window
linking, 1.7Opens a new window
GENXTB form
how to run, 20.12Opens a new window
use with user exits, 20.12Opens a new window
GENXTB utility
how to run, 20.12Opens a new window
use with user exits, 20.12Opens a new window
GET DESCRIPTOR statement, 14.5.3Opens a new window
Globalization Support, 4.10Opens a new window
GOTO action
in the WHENEVER statement, 9.9.2.5Opens a new window
of WHENEVER directive, E.78Opens a new window
result of, 9.9.2.5Opens a new window
guidelines
for dynamic SQL, 13.6.5Opens a new window
for separate precompilations, 2.5.1Opens a new window
for the WHENEVER statement, 9.9.6Opens a new window
for transactions, 3.14.1Opens a new window

H

HEOpens a new window  HFOpens a new window  HIOpens a new window  HOOpens a new window 
header files
location of, 5.5.4Opens a new window
oraca.h, 5.5.4Opens a new window, 5.5.4Opens a new window
sql2oci.h, 5.5.4Opens a new window, 5.5.4Opens a new window
sqlapr.h, 5.5.4Opens a new window, 5.5.4Opens a new window
sqlca.h, 5.5.4Opens a new window
sqlcpr.h, 5.5.4Opens a new window
HEADER precompiler option, 5.5Opens a new window, 10.5.25Opens a new window
heap
definition of, 9.11.4Opens a new window
HFILE OTT parameter, 19.5.2.7Opens a new window
hints
COST, B.5.1Opens a new window
for the ORACLE SQL statement optimizer, 6.7Opens a new window
in DELETE statements, E.28Opens a new window
in SELECT statements, E.73Opens a new window
in UPDATE statements, E.76Opens a new window
HOLD_CURSOR
precompiler option
used to improved performance, B.9.2.4Opens a new window
what it affects, B.9Opens a new window
HOLD_CURSOR option
of ORACLE Precompilers, E.8Opens a new window
HOLD_CURSOR precompiler option, 10.5.25Opens a new window
host arrays
advantages of, 8.1Opens a new window
declaring, 8.2Opens a new window, 8.2Opens a new window
dimensioning, 8.2Opens a new window
in the DELETE statement, 8.7Opens a new window
in the INSERT statement, 8.5Opens a new window
in the SELECT statement, 8.4Opens a new window
in the UPDATE statement, 8.6Opens a new window
in the WHERE clause, 8.9Opens a new window
matching sizes of, 8.3.1Opens a new window
referencing, 8.2.1Opens a new window, 8.3.1Opens a new window
restrictions on, 8.3.3Opens a new window, 8.4.7Opens a new window, 8.5.1Opens a new window, 8.6.1Opens a new window, 8.7.1Opens a new window
used as input host variables, 8.3Opens a new window
used as output host variables, 8.3Opens a new window
using in dynamic SQL method 4, 15.6.19Opens a new window
using in dynamic SQL statements, 13.11.1Opens a new window
using the FOR clause with, 8.8Opens a new window
using to improve performance, B.3Opens a new window
when not allowed, 8.2.1Opens a new window
host language
definition of, 2.1.1Opens a new window, 2.1.1.1Opens a new window
host program
definition of, 2.1.1Opens a new window
host structures
arrays in, 4.8.1Opens a new window
declaring, 4.8Opens a new window
host variables, 6.1.1Opens a new window
assigning values to, 2.1.5Opens a new window
declarations, 18.2.1Opens a new window
declaring, 2.3.3Opens a new window, 18.2.1Opens a new window
definition of, 2.1.5Opens a new window
dummy, 13.4Opens a new window
host variable equivalencing, E.77Opens a new window
in EXECUTE statement, E.33Opens a new window
in OPEN statement, E.67Opens a new window
in user exits, 20.4.1Opens a new window
input versus output, 6.1.1Opens a new window
must resolve to an address, 4.2.2.1Opens a new window
overview of, 2.1.5Opens a new window
purpose of, 6.1Opens a new window
restrictions on, 4.2.2.1Opens a new window
rules for naming, 2.3.8Opens a new window
using in PL/SQL, 7.3Opens a new window

I

IAOpens a new window  IDOpens a new window  IMOpens a new window  INOpens a new window 
I variable in SQLDA
how value is set, 15.3.5Opens a new window
purpose of, 15.3.5Opens a new window
IAP in SQL*Forms
purpose of, 20.13Opens a new window
identifiers, ORACLE
how to form, E.3.5Opens a new window
implicit connections, 3.2.5Opens a new window
multiple, 3.2.5.2Opens a new window
single, 3.2.5.1Opens a new window
IN OUT parameter mode, 7.1.4Opens a new window
IN parameter mode, 7.1.4Opens a new window
INAME precompiler option, 10.5.28Opens a new window
INCLUDE
precompiler option, use of, 5.4.7Opens a new window
using to include the SQLCA, 9.7.1Opens a new window
INCLUDE option, 10.2.7.4Opens a new window
INCLUDE precompiler option, D.1.11Opens a new window
INCLUDE, SYS_INCLUDE Precompiler Options, 10.2.1Opens a new window
indexes
using to improve performance, B.7Opens a new window
indicator arrays, 8.3.2Opens a new window
example of using, 8.3.2Opens a new window
uses for, 8.3.2Opens a new window
INDICATOR keyword, 4.3.1Opens a new window
indicator variables
assigning values to, 6.2Opens a new window
association with host variables, 6.2Opens a new window
declarations, 18.2.1Opens a new window
declaring, 4.3Opens a new window, 18.2.1Opens a new window
definition of, 2.1.5Opens a new window
function of, 6.2Opens a new window
guidelines, 4.3.3Opens a new window
interpreting values of, 6.2Opens a new window
naming of, 4.8.4Opens a new window
referencing, 4.3Opens a new window
requirements for, 6.2Opens a new window
used with multibyte character strings, 4.11.6Opens a new window
using in PL/SQL, 7.4Opens a new window
using to detect NULLs, 6.2Opens a new window
using to detect truncated values, 6.2Opens a new window
using to insert NULLs, 6.2.1Opens a new window
using to return NULLs, 6.2.2Opens a new window
using to test for NULLs, 6.2.4Opens a new window
with structures, 4.8.4Opens a new window
in-doubt transaction, 3.13Opens a new window
INITFILE OTT parameter, 19.5.2.5Opens a new window
INITFUNC OTT parameter, 19.5.2.6Opens a new window
initialization function
calling, 19.3.2Opens a new window
tasks of, 19.3.3Opens a new window
input host variables
assigning values to, 6.1.1Opens a new window
definition of, 6.1.1Opens a new window
restrictions on, 6.1.1Opens a new window
uses for, 6.1.1Opens a new window
where allowed, 6.1.1Opens a new window
INSERT SQL statement, E.40Opens a new window
examples, E.40Opens a new window
INSERT statement
column list in, 6.3.2Opens a new window
example of, 6.3.2Opens a new window
INTO clause in, 6.3.2Opens a new window
purpose of, 6.3.2Opens a new window
requirements for, 6.3.2Opens a new window
using host arrays in, 8.5Opens a new window
VALUES clause in, 6.3.2Opens a new window
inserting
rows into tables and views, E.40Opens a new window
INTEGER datatype, 4.1.2.3Opens a new window
interface
native, 5.12Opens a new window
XA, 5.12Opens a new window
internal datatypes
definition of, 2.1.6Opens a new window
INTERVAL DAY TO SECOND datatype, 4.1.3.7Opens a new window
INTERVAL YEAR TO MONTH datatype, 4.1.3.6Opens a new window
INTO clause
for output host variables, 6.1.1Opens a new window
in FETCH statements, 6.5.3Opens a new window
in INSERT statements, 6.3.2Opens a new window
in SELECT statements, 6.3.1Opens a new window
of FETCH DESCRIPTOR statement, E.37Opens a new window
of FETCH statement, E.36Opens a new window
of SELECT statement, E.73Opens a new window
used with FETCH instead of SELECT, 6.5.1Opens a new window
intype file, 19.5.4Opens a new window
providing when running OTT, 19.2.4Opens a new window
structure of, 19.5.4Opens a new window
INTYPE OTT parameter, 19.5.2.2Opens a new window
INTYPE precompiler option, 10.5.30Opens a new window
invalid use
of precompiler preprocessor, 5.4.5.1Opens a new window

J

JOOpens a new window 
joins
restriction on, 6.9.1Opens a new window

L

LAOpens a new window  LDOpens a new window  LIOpens a new window  LNOpens a new window  LOOpens a new window  LTOpens a new window  LVOpens a new window 
L variable in SQLDA
how value is set, 15.3.3Opens a new window
purpose of, 15.3.3Opens a new window
label name
maximum length of, 9.9.2.5Opens a new window
large objects, F.1Opens a new window
LDA, 5.10Opens a new window
remote and multiple connections, 5.10.2Opens a new window
setup for OCI version 8, 5.10.1Opens a new window
lines
continuation, 2.3.9Opens a new window
maximum length, 2.3.10Opens a new window
LINES precompiler option, 10.5.31Opens a new window
link
database link, 3.2.5.1Opens a new window
linking, 1.7Opens a new window, 2.6Opens a new window
on UNIX, 1.8.11Opens a new window
on VMS, 1.8.11Opens a new window
two-task, 2.6Opens a new window
Linking in an XA Library, D.1.8Opens a new window
LNAME precompiler option, 10.5.32Opens a new window
LNPROC
VMS link script, 1.8.11Opens a new window
LOB APPEND SQL statement, E.41Opens a new window
LOB APPEND statement, 16.4.1Opens a new window
LOB ASSIGN SQL statement, E.42Opens a new window
LOB ASSIGN statement, 16.4.2Opens a new window
LOB CLOSE SQL statement, E.43Opens a new window
LOB CLOSE statement, 16.4.3Opens a new window
LOB COPY SQL statement, E.44Opens a new window
LOB COPY statement, 16.4.4Opens a new window
LOB CREATE TEMPORARY SQL statement, E.45Opens a new window
LOB CREATE temporary statement, 16.4.5Opens a new window
LOB DESCRIBE SQL statement, E.46Opens a new window
LOB DISABLE BUFFERING SQL statement, E.47Opens a new window
LOB DISABLE BUFFERING statement, 16.4.6Opens a new window
LOB ENABLE BUFFERING SQL statement, E.48Opens a new window
LOB ENABLE BUFFERING statement, 16.4.7Opens a new window
LOB ERASE SQL statement, E.49Opens a new window
LOB ERASE statement, 16.4.8Opens a new window
LOB FILE CLOSE ALL SQL statement, E.50Opens a new window
LOB file close all statement, 16.4.9Opens a new window
LOB FILE CLOSE ALL statement, 16.4.9Opens a new window
LOB FILE SET SQL statement, E.51Opens a new window
LOB FILE SET statement, 16.4.10Opens a new window
LOB FLUSH BUFFER SQL statement, E.52Opens a new window
LOB FLUSH BUFFER statement, 16.4.11Opens a new window
LOB FREE TEMPORARY SQL statement, E.53Opens a new window
LOB FREE TEMPORARY statement, 16.4.12Opens a new window
LOB LOAD FROM FILE statement, 16.4.13Opens a new window
LOB LOAD SQL statement, E.54Opens a new window
LOB OPEN SQL statement, E.55Opens a new window
LOB OPEN statement, 16.4.14Opens a new window
LOB READ SQL statement, E.56Opens a new window
LOB READ statement, 16.4.15Opens a new window
LOB TRIM SQL statement, E.57Opens a new window
LOB WRITE SQL statement, E.58Opens a new window
LOBs, F.1Opens a new window
access methods, 16.2.1Opens a new window
BFILES, 16.1.2Opens a new window
buffering system, 16.3.2Opens a new window
external, 16.1.2Opens a new window
initializing, 16.2.3Opens a new window
internal, 16.1.1Opens a new window
locators, 16.1.5Opens a new window
locators in C, 16.2.2Opens a new window
temporary, 16.1.6Opens a new window
Location of Included Files, D.1.2Opens a new window
location of the Pro*C/C++ Executable, D.1.9Opens a new window
location transparency
how provided, 3.2.5.1Opens a new window
lock
released by ROLLBACK statement, E.71Opens a new window
LOCK TABLE statement
closes mall cursors, 3.11.2Opens a new window
example of, 3.11.2Opens a new window
locking tables with, 3.11.2Opens a new window
NOWAIT parameter in, 3.11.2Opens a new window
purpose of, 3.11.2Opens a new window
locking, 3.11Opens a new window
definition of, 3.3Opens a new window
explicit versus implicit, 3.11Opens a new window
modes of, 3.3Opens a new window
overriding default, 3.11Opens a new window
privileges needed to obtain, 3.14.2Opens a new window
table versus row, 3.11Opens a new window
uses for, 3.11Opens a new window
with FOR UPDATE OF, 3.11Opens a new window
with the LOCK TABLE statement, 3.11.2Opens a new window
logon, 3.1Opens a new window
Logon Data Area, 5.10Opens a new window
LONG datatype, 4.1.2.7Opens a new window
LONG RAW datatype, 4.1.2.13Opens a new window
LONG VARCHAR
datatype, 4.1.2.15Opens a new window
LONG VARRAW datatype, 4.1.2.16Opens a new window
LTYPE precompiler option, 10.5.33Opens a new window
lvalue, 4.2Opens a new window

M

MAOpens a new window  MEOpens a new window  MIOpens a new window  MOOpens a new window  MSOpens a new window  MUOpens a new window 
M variable in SQLDA
how value is set, 15.3.8Opens a new window
purpose of, 15.3.8Opens a new window
macro precompiler options, 10.2.4Opens a new window
malloc()
example of using, 15.6.14Opens a new window
purpose of, 15.6.14Opens a new window
MAXLITERAL
default value for, 2.3.11Opens a new window
MAXLITERAL precompiler option, 10.5.35Opens a new window
MAXOPENCURSORS
precompiler option
effect on performance, B.9.2.2Opens a new window
for multiple cursors, 6.5.1Opens a new window
specifying for separate precompilation, 2.5.1.2Opens a new window
what it affects, B.9Opens a new window
MAXOPENCURSORS precompiler option, 10.5.36Opens a new window
MEMFORPREFETCH precompiler option, 10.5.53Opens a new window
metadata, 18.4.7Opens a new window
micro precompiler options, 10.2.4Opens a new window
Microsoft Visual Studio
integrating Pro*C/C++ into, GOpens a new window
migration
include files, 5.4.10Opens a new window
MODE interaction with DBMS, 10.5.16Opens a new window
MODE precompiler option, 10.5.37Opens a new window
modes, parameter, 7.1.4Opens a new window
msvcrt.lib runtime library, 1.7Opens a new window
multithreaded applications, F.1Opens a new window
sample program, 11.5Opens a new window
user-interface features
embedded SQL statements and directives, 11.4.2Opens a new window

N

NAOpens a new window  NEOpens a new window  NLOpens a new window  NOOpens a new window  NUOpens a new window 
N variable in SQLDA
how value is set, 15.3.1Opens a new window
purpose of, 15.3.1Opens a new window
naming
of cursors, 6.5.1Opens a new window
of database objects, E.3.5Opens a new window
of select-list items, 15.2.1Opens a new window
of SQL*Forms user exits, 20.14.1Opens a new window
NATIVE
value of DBMS option, 10.5.15Opens a new window, 10.5.16Opens a new window
native interface, 5.12Opens a new window
navigational access sample program, 17.11Opens a new window
nested tables, 18.1.1Opens a new window
creation, 18.1.1Opens a new window
network
communicating over, 3.2.1Opens a new window
protocols, 3.2.1Opens a new window
reducing traffic, B.4Opens a new window
NLS parameters, 4.10Opens a new window
NLS_CURRENCY, 4.10Opens a new window
NLS_DATE_FORMAT, 4.10Opens a new window
NLS_DATE_LANGUAGE, 4.10Opens a new window
NLS_ISO_CURRENCY, 4.10Opens a new window
NLS_LANG, 4.10Opens a new window
NLS_LANGUAGE, 4.10Opens a new window
NLS_NUMERIC_CHARACTERS, 4.10Opens a new window
NLS_TERRITORY, 4.10Opens a new window
NLS_CHAR precompiler option, 10.5.38Opens a new window, 10.5.39Opens a new window
NLS_LOCAL precompiler option, 10.5.40Opens a new window
node
current, 3.2.3Opens a new window
definition of, 3.2.1Opens a new window
NOT FOUND condition
in the WHENEVER statement, 9.9.1.3Opens a new window
meaning of, 9.9.1.3Opens a new window
of WHENEVER directive, E.78Opens a new window
NOWAIT parameter
effect of, 3.11.2Opens a new window
in LOCK TABLE statements, 3.11.2Opens a new window
omitting, 3.11.2Opens a new window
NULLs
definition of, 2.1.5Opens a new window
detecting, 6.2Opens a new window
handling in dynamic SQL method 4, 15.4.3Opens a new window
hardcoding, 6.2.1Opens a new window
inserting, 6.2.1Opens a new window
restrictions on, 6.2.4Opens a new window
returning, 6.2.2Opens a new window
testing for, 6.2.4Opens a new window
using the sqlnul() function to test for, 15.4.3Opens a new window
null-terminated strings, 4.1.2.5.2Opens a new window
NUMBER datatype, 4.1.2.2Opens a new window
using the sqlprc() function with, 15.4.2.1Opens a new window
numeric expressions
cannot serve as host variables, 4.2.2.1Opens a new window

O

OBOpens a new window  OCOpens a new window  ONOpens a new window  OPOpens a new window  OROpens a new window  OTOpens a new window  OUOpens a new window  OVOpens a new window 
object cache, 17.3Opens a new window
OBJECT CREATE SQL statement, 17.5.3Opens a new window, E.59Opens a new window
OBJECT DELETE SQL statement, 17.5.6Opens a new window, E.60Opens a new window
OBJECT DEREF SQL statement, 17.5.4Opens a new window, E.61Opens a new window
OBJECT FLUSH SQL statement, E.62Opens a new window
OBJECT FLUSH SQL statements, 17.5.8Opens a new window
OBJECT GET SQL statement, 17.6.2Opens a new window, E.63Opens a new window
OBJECT RELEASE SQL statement, E.64Opens a new window
OBJECT SET SQL statement, 17.6.1Opens a new window, E.65Opens a new window
Object Type Translator (OTT), F.4Opens a new window
command line, 19.2.3Opens a new window
command line syntax, 19.5.1Opens a new window
creating types in the database, 19.2.1Opens a new window
default name mapping, 19.5.7Opens a new window
outtype file, 19.2.8Opens a new window
parameters, 19.5.2Opens a new window
providing an intype file, 19.2.4Opens a new window
reference, 19.5Opens a new window
restriction, 19.5.8Opens a new window
using, 19Opens a new window, 19.2Opens a new window
using with Pro*C/C++, 19.4Opens a new window
OBJECT UPDATE SQL statement, 17.5.7Opens a new window, E.66Opens a new window
objects
accessing with OCI, 19.3.1Opens a new window
demonstration program, F.1Opens a new window
introduction to, 17.1Opens a new window
manipulating with OCI, 19.3.1Opens a new window
persistent, 17.3.1Opens a new window
persistent versus transient copies of, 17.3.1Opens a new window
references to, 17.1.2Opens a new window
support, 17Opens a new window
transient, 17.3.1Opens a new window
types, 17.1.1Opens a new window
using object types in Pro*C/C++, 17.2Opens a new window
OBJECTS precompiler option, 10.5.23Opens a new window, 10.5.41Opens a new window, 17.8.3Opens a new window
OCI applications
using the OTT with, 19.3Opens a new window
OCI calls, 1.8.3Opens a new window
embedding, 5.10Opens a new window
in an X/A environment, 5.12.1.3Opens a new window
OCI onblon() call
not used to connect, 5.10Opens a new window
OCI orlon() call
not used to connect, 5.10Opens a new window
OCI Release 8, 5.8Opens a new window
accessing and manipulating objects, 19.3.1Opens a new window
embedding in Pro*C/C++, 5.9.3Opens a new window
interfacing to, 5.9Opens a new window
parameters in the environment handle, 5.8.2Opens a new window
SQLLIB extensions, 5.8Opens a new window
OCI types
declaring, 17.14.1Opens a new window
manipulating, 17.14.3Opens a new window
OCIDate, 17.14Opens a new window
OCINumber, 17.14Opens a new window
OCIRaw, 17.14Opens a new window
OCIString, 17.14Opens a new window
using in embedded SQL, 17.14.2Opens a new window
OCIDate, 17.14Opens a new window
declaring, 17.14.1Opens a new window
ocidfn.h, 5.10Opens a new window
OCINumber, 17.14Opens a new window
declaring, 17.14.1Opens a new window
OCIRaw, 17.14Opens a new window
declaring, 17.14.1Opens a new window
OCIString, 17.14Opens a new window
declaring, 17.14.1Opens a new window
ONAME precompiler option, 10.5.42Opens a new window
OPEN CURSOR statement, 14.5.11Opens a new window
OPEN DESCRIPTOR SQL statement, E.68Opens a new window
OPEN SQL statement, E.67Opens a new window
OPEN statement, 6.5.2Opens a new window
dependence on precompiler options, 6.5.2Opens a new window
effect of, 6.5.2Opens a new window
example of, 6.5.2Opens a new window
examples, E.67Opens a new window
purpose of, 6.5Opens a new window, 6.5.2Opens a new window
use in dynamic SQL method 3, 13.9.3Opens a new window
use in dynamic SQL method 4, 15.6.11Opens a new window
opening
a cursor variable, 4.5.3Opens a new window
cursors, E.67Opens a new window, E.68Opens a new window
operators
C versus SQL, 2.3.12Opens a new window
restrictions on, 2.3.12Opens a new window
optimization approach, B.5.1Opens a new window
optimizer hints, B.5.1Opens a new window
in C, 6.7Opens a new window
in C++, 6.7.1Opens a new window, 12.2.1Opens a new window
ORACA, 9.3.2Opens a new window
example of using, 9.11.6Opens a new window
using to gather cursor cache statistics, 9.11.5.11Opens a new window
ORACA precompiler option, 10.5.27Opens a new window, 10.5.34Opens a new window, 10.5.43Opens a new window, 10.5.44Opens a new window, 10.5.45Opens a new window, 10.5.56Opens a new window
oraca.h header file, 5.5.4Opens a new window, 5.5.4Opens a new window
ORACAID component, 9.11.5.1Opens a new window
Oracle
datatypes, 2.1.6Opens a new window
Forms Version 4, 20.5Opens a new window
Open Gateway
using the ROWID datatype with, 4.1.2.9Opens a new window
Toolset, 20.5Opens a new window
Oracle Call Interface version 7, 5.10Opens a new window
Oracle Communications Area, 9.11Opens a new window
Oracle names
how to form, E.3.5Opens a new window
Oracle Net
connecting to Oracle through, 3.2.2Opens a new window
connection syntax, 3.2.1Opens a new window
for concurrent connections, 3.2.2Opens a new window
function of, 3.2.1Opens a new window
Oracle Net Services
connecting, 3.1.2Opens a new window
orasql9.lib, G.2.2Opens a new window
orasql9.lib library file, 1.7Opens a new window
OTT (Object Type Translator), F.4Opens a new window
OTT parameter TRANSITIVE, 19.5.2.12Opens a new window
OTT parameters
CASE, 19.5.2.10Opens a new window
CODE, 19.5.2.4Opens a new window
CONFIG, 19.5.2.8Opens a new window
ERRTYPE, 19.5.2.9Opens a new window
HFILE, 19.5.2.7Opens a new window
INITFILE, 19.5.2.5Opens a new window
INITFUNC, 19.5.2.6Opens a new window
INTYPE, 19.5.2.2Opens a new window
OUTTYPE, 19.5.2.3Opens a new window
SCHEMA_NAMES, 19.5.2.11Opens a new window
USERID, 19.5.2.1Opens a new window
where they appear, 19.5.3Opens a new window
OUT parameter mode, 7.1.4Opens a new window
output host variables
assigning values to, 6.1.1Opens a new window
definition of, 6.1.1Opens a new window
outtype file, 19.5.4Opens a new window
when running OTT, 19.2.8Opens a new window
OUTTYPE OTT parameter, 19.5.2.3Opens a new window
overhead
reducing, B.2Opens a new window

P

PAOpens a new window  PCOpens a new window  PEOpens a new window  PLOpens a new window  POOpens a new window  PROpens a new window 
PAGELEN
precompiler option, 10.5.46Opens a new window
parameter modes, 7.1.4Opens a new window
PARSE
precompiler option, 10.5.47Opens a new window
parse error offset
how to interpret, 9.6.4Opens a new window
use in error reporting, 9.6.4Opens a new window
PARSE option, 10.2.7.5Opens a new window
parsing dynamic statements
PREPARE statement, E.69Opens a new window
password
defining, 3.1Opens a new window
paths
checking, F.4Opens a new window
checking the .pre files, F.5Opens a new window
pcmake.bat, F.3.1Opens a new window
pcscfg.cfg configuration file, 10.2.7.1Opens a new window
performance
eliminating extra parsing to improve, B.9Opens a new window
optimizing SQL statements to improve, B.5Opens a new window
reasons for poor, B.1Opens a new window
using embedded PL/SQL to improve, B.4Opens a new window
using HOLD_CURSOR to improve, B.9.2.4Opens a new window
using host arrays to improve, B.3Opens a new window
using indexes to improve, B.7Opens a new window
using RELEASE_CURSOR to improve, B.9.2.4Opens a new window
using row-level locking to improve, B.8Opens a new window
persistent copies of objects, 17.3.1Opens a new window
persistent objects, 17.3.1Opens a new window
placeholders
duplicate, 13.8.1Opens a new window, 13.12.2Opens a new window
naming, 13.8.1Opens a new window
proper order of, 13.8.1Opens a new window
use in dynamic SQL statements, 13.4Opens a new window
PLAN_BASELINE
precompiler option, 10.5.48Opens a new window
PLAN_ENABLED
precompiler option, 10.5.52Opens a new window
PLAN_FIXED
precompiler option, 10.5.51Opens a new window
PLAN_PREFIX
precompiler option, 10.5.49Opens a new window
PLAN_RUN
precompiler option, 10.5.50Opens a new window
PL/SQL, 1.4Opens a new window
anonymous block
used to open a cursor variable, 4.5.3Opens a new window
cursor FOR loop, 7.1.3Opens a new window
description of, 1.4Opens a new window
difference from SQL, 1.4Opens a new window
executing a block using the AT clause, 3.2.4.1.2Opens a new window
integration with database server, 7.1.2Opens a new window
main advantage of, 1.4Opens a new window
packages, 7.1.5Opens a new window
PL/SQL tables, 7.1.6Opens a new window
procedures and functions, 7.1.4Opens a new window
RECORD type
cannot be bound to a C struct, 4.8.2Opens a new window
relationship with SQL, 1.4Opens a new window
setting SQLCA, 9.7.4Opens a new window
user-defined records, 7.1.7Opens a new window
PL/SQL blocks
embedded in precompiler programs, E.32Opens a new window
pointer
definition of, 4.9Opens a new window
to cursor variables
restrictions on, 4.5.1Opens a new window
pointer variables
declaring, 4.9.1Opens a new window
determining size of referenced value, 4.9.2Opens a new window
referencing, 4.9.2Opens a new window
referencing struct members with, 4.9.2Opens a new window
.pre files
checking the paths, F.5Opens a new window
precedence of precompiler options, 10.2.3Opens a new window, 10.2.3Opens a new window
precision
definition of, 15.4.2.1Opens a new window
using sqlprc() to extract, 15.4.2.1Opens a new window
when not specified, 15.4.2.1Opens a new window
precompilation
conditional, 2.4Opens a new window
separate, 2.5Opens a new window, 2.5Opens a new window
precompilation unit, 3.1Opens a new window, 10.3Opens a new window
precompiled header files, 5.5Opens a new window
C++ restrictions, 5.5.5.2Opens a new window
CODE option, 5.5.5.2Opens a new window, 5.5.5.2Opens a new window
PARSE option, 5.5.5.2Opens a new window
precompiler options
alphabetized list, 10.3Opens a new window, 10.5Opens a new window
AUTO_CONNECT, 10.5.1Opens a new window
case sensitivity, 10.1.1Opens a new window
CHAR_MAP, 5.1.1Opens a new window, 10.5.2Opens a new window
CLOSE_ON_COMMIT, 6.5.1Opens a new window, 6.6.2Opens a new window, 10.5.4Opens a new window
CODE, 10.5.8Opens a new window, 10.5.8Opens a new window
COMP_CHARSET, 10.5.9Opens a new window, 10.5.9Opens a new window, 10.5.10Opens a new window, 10.5.10Opens a new window
CONFIG, 10.5.3Opens a new window, 10.5.5Opens a new window, 10.5.6Opens a new window, 10.5.7Opens a new window, 10.5.11Opens a new window, 10.5.12Opens a new window, 10.5.14Opens a new window
configuration files, 10.2.2Opens a new window
CPP_SUFFIX, 10.5.13Opens a new window, 10.5.13Opens a new window
DBMS, 10.5.15Opens a new window, 10.5.16Opens a new window
DEF_SQLCODE, 10.5.17Opens a new window
DEFINE, 10.5.18Opens a new window
determining current value, 10.2.3Opens a new window
DURATION, 10.5.20Opens a new window
DYNAMIC, 14.4Opens a new window
entering, 10.4Opens a new window
entering on the command line, 10.4.1Opens a new window
ERRORS, 10.5.21Opens a new window
ERRTYPE, 10.5.22Opens a new window
FIPS, 10.5.24Opens a new window
HEADER, 10.5.25Opens a new window
HOLD_CURSOR, 10.5.25Opens a new window, 10.5.26Opens a new window
INAME, 10.5.28Opens a new window
INCLUDE, 10.5.29Opens a new window, 10.5.29Opens a new window
INTYPE, 10.5.30Opens a new window
LINES, 10.5.31Opens a new window
list of, 10.5Opens a new window
LNAME, 10.5.32Opens a new window
LTYPE, 10.5.33Opens a new window
MAXLITERAL, 2.3.11Opens a new window, 10.5.35Opens a new window
MAXOPENCURSORS, 10.5.36Opens a new window
MEMFORPREFETCH, 10.5.53Opens a new window
micro and macro, 10.2.4Opens a new window
MODE, 10.5.37Opens a new window, 14.4Opens a new window
NLS_CHAR, 10.5.38Opens a new window, 10.5.39Opens a new window
NLS_LOCAL, 10.5.40Opens a new window
OBJECTS, 10.5.23Opens a new window, 10.5.41Opens a new window
ONAME, 10.5.42Opens a new window
ORACA, 10.5.27Opens a new window, 10.5.34Opens a new window, 10.5.43Opens a new window, 10.5.44Opens a new window, 10.5.45Opens a new window, 10.5.56Opens a new window
PAGELEN, 10.5.46Opens a new window
PARSE, 10.5.47Opens a new window
PLAN_BASELINE, 10.5.48Opens a new window
PLAN_ENABLED, 10.5.52Opens a new window
PLAN_FIXED, 10.5.51Opens a new window
PLAN_PREFIX, 10.5.49Opens a new window
PLAN_RUN, 10.5.50Opens a new window
precedence, 10.2.3Opens a new window
PREFETCH, 10.5.54Opens a new window
RELEASE_CURSOR, 10.5.55Opens a new window
scope, 10.2.6Opens a new window
scope of, 10.3Opens a new window
SELECT_ERROR, 10.5.57Opens a new window, 10.5.58Opens a new window
specifying, 10.4.1Opens a new window
SQLCHECK, 17.8.6Opens a new window
syntax for, 10.4.1Opens a new window
SYS_INCLUDE, 10.5.59Opens a new window
THREADS, 10.5.60Opens a new window, 11.4.1Opens a new window
TYPE_CODE, 10.5.61Opens a new window, 14.4Opens a new window
UNSAFE_NULL, 10.5.62Opens a new window
USERID, 10.5.63Opens a new window
using, 10.5Opens a new window
VARCHAR, 10.5.65Opens a new window
VERSION, 10.5.66Opens a new window
Precompiler Options, SYS_INCLUDE, INCLUDE, 10.2.1Opens a new window
predefined symbols, 2.4.1Opens a new window
PREFETCH precompiler option, 6.6.3Opens a new window, 10.5.54Opens a new window
PREPARE SQL statement, E.69Opens a new window
PREPARE statement, 14.5.5Opens a new window
effect on data definition statements, 13.6.2Opens a new window
examples, E.69Opens a new window
use in dynamic SQL, 13.8Opens a new window, 13.9.1Opens a new window
use in dynamic SQL method 4, 15.6.6Opens a new window
preprocessor
example, 5.6.2Opens a new window
EXEC ORACLE directives, 5.6Opens a new window
preprocessor directives
directives not supported by Pro*C, 5.4.2.1Opens a new window
preprocessor, support of, 4.1Opens a new window
private SQL area
association with cursors, 2.1.9Opens a new window
definition of, 2.1.9Opens a new window
opening of, 2.1.9Opens a new window
purpose of, B.9.2.1Opens a new window
Pro*C/C++
configuration files, 10.2.7.1Opens a new window
integrating into Microsoft Visual Studio, GOpens a new window
library file, G.2.2Opens a new window
linking, 1.7Opens a new window
Pro*C/C++ Precompiler
common uses for, 1.2Opens a new window
Globalization Support, 4.10Opens a new window
new database types, 17.15Opens a new window
object support in, 17Opens a new window
runtime context, 5.8.1Opens a new window
use of PL/SQL with, 7.2Opens a new window
using OTT with, 19.4Opens a new window
procedural database extension, 7.1.5Opens a new window
program termination
normal versus abnormal, 3.9Opens a new window
programming guidelines, 2.3Opens a new window
project files, F.4Opens a new window

Q

QUOpens a new window 
queries
association with cursors, 6.5Opens a new window
forwarding, 3.2.5.1Opens a new window
incorrectly coded, 6.3.1Opens a new window
kinds of, 6.3Opens a new window
requirements for, 6.3Opens a new window
returning more than one row, 6.3Opens a new window
single-row versus multirow, 6.3.1Opens a new window

R

RAOpens a new window  REOpens a new window  ROOpens a new window  RUOpens a new window 
RAW datatype, 4.1.2.11Opens a new window
READ ONLY parameter
in SET TRANSACTION statement, 3.10Opens a new window
read-only transactions
description of, 3.10Opens a new window
example of, 3.10Opens a new window
how ended, 3.10Opens a new window
record, 7.1.7Opens a new window
REF
structure for, 17.13.1Opens a new window
REF (reference to object), 17.1.2Opens a new window
REFERENCE clause
in TYPE statement, 5.3.2.1Opens a new window
reference semantics (ANSI dynamic SQL), 14.3.1Opens a new window
references to objects (REFs)
declaring, 17.13.2Opens a new window
using, 17.13Opens a new window
using in embedded SQL, 17.13.3Opens a new window
referencing
of host arrays, 8.2.1Opens a new window, 8.3.1Opens a new window
REFs
declaring, 17.13.2Opens a new window, 17.13.2Opens a new window
using, 17.13Opens a new window, 17.13Opens a new window
using in embedded SQL, 17.13.3Opens a new window
REGISTER CONNECT SQL statement, E.70Opens a new window
RELEASE option, 3.9Opens a new window
if omitted, 3.9Opens a new window
in COMMIT statement, 3.6Opens a new window
in ROLLBACK statement, 3.8Opens a new window
purpose of, 3.6Opens a new window
restriction on, 3.8Opens a new window
RELEASE_CURSOR
precompiler option
what it affects, B.9Opens a new window
RELEASE_CURSOR option
of ORACLE Precompilers, E.8Opens a new window
using to improve performance, B.9.2.4Opens a new window
RELEASE_CURSOR precompiler option, 10.5.55Opens a new window
remote database
declaration of, E.24Opens a new window
reserved namespaces, A.2Opens a new window
reserved words and keywords, A.1Opens a new window
resource manager, 5.12Opens a new window
restrictions
on AT clause, 3.2.4.1.3Opens a new window
on Comments, 13.12.4Opens a new window
on CURRENT OF clause, 6.9.1Opens a new window
on declaring cursors, 6.5.1Opens a new window
on FOR clause, 8.8.1Opens a new window
on host arrays, 8.3.3Opens a new window, 8.4.7Opens a new window, 8.5.1Opens a new window, 8.6.1Opens a new window, 8.7.1Opens a new window
on input host variables, 6.1.1Opens a new window
on NULLs, 6.2.4Opens a new window
on separate precompilation, 2.5.1.1Opens a new window
on SET TRANSACTION statement, 3.10Opens a new window
use of CURRENT OF clause, 8.3.3Opens a new window
retrieving rows from a table
embedded SQL, E.73Opens a new window
return codes
user exits, 20.8Opens a new window
returning clause
DELETE, 6.3.4Opens a new window
in INSERT, 6.4Opens a new window
in UPDATE, 6.3.3Opens a new window
returning clauses, 6.4Opens a new window
roll back
to a savepoint, E.72Opens a new window
to the same savepoint multiple times, E.71Opens a new window
ROLLBACK
signal handler single thread limitation, 9.2Opens a new window
ROLLBACK SQL statement, E.71Opens a new window
ROLLBACK statement, 3.8Opens a new window
effect of, 3.8Opens a new window
ending a transaction, E.71Opens a new window
example of, 3.8Opens a new window
examples, E.71Opens a new window
in error handling routines, 3.8Opens a new window
purpose of, 3.8Opens a new window
RELEASE option in, 3.8Opens a new window
TO SAVEPOINT clause in, 3.8Opens a new window
using in a PL/SQL block, 3.14.3Opens a new window
where to place, 3.8Opens a new window
rollbacks
automatic, 3.8Opens a new window
function of, 3.4Opens a new window
statement-level, 3.8.1Opens a new window
row locks
acquiring with FOR UPDATE OF, 3.11.1Opens a new window
advantage of, B.8Opens a new window
using to improve performance, B.8Opens a new window
when acquired, 3.11.1.1Opens a new window
when released, 3.11.1.1Opens a new window
ROWID
logical, 4.1.2.9Opens a new window
pseudocolumn, 3.12Opens a new window
using to mimic CURRENT OF, 3.12Opens a new window, 8.11Opens a new window
universal, 4.1.2.9Opens a new window, 4.1.2.9Opens a new window
ROWID datatype, 4.1.2.9Opens a new window
rows
fetching from cursors, E.36Opens a new window, E.37Opens a new window
inserting into tables and views, E.40Opens a new window
updating, E.76Opens a new window
rows-processed count
use in error reporting, 9.6.3Opens a new window
runtime context
establishing, 5.8.1Opens a new window
terminating, 5.8.1Opens a new window
runtime type checking, 17.8.7Opens a new window

S

SAOpens a new window  SCOpens a new window  SEOpens a new window  SIOpens a new window  SQOpens a new window  STOpens a new window  SUOpens a new window  SYOpens a new window 
S variable in SQLDA
how value is set, 15.3.7Opens a new window
purpose of, 15.3.7Opens a new window
sample database tables
DEPT table, 2.7Opens a new window
EMP table, 2.7Opens a new window
sample object type code, 17.11Opens a new window
sample programs
ANSIDYN1, F.1Opens a new window, F.1Opens a new window
ansidyn1.pc, 14.6.1Opens a new window
ANSIDYN2, F.1Opens a new window, F.1Opens a new window
ansidyn2.pc, 14.6.2Opens a new window
building, F.3Opens a new window
calldemo.sql, with sample9.pc, 7.7.2.1Opens a new window
COLDEMO1, F.1Opens a new window, F.1Opens a new window
coldemo1.pc, 18.5.5Opens a new window
CPPDEMO1, F.1Opens a new window, F.1Opens a new window
cppdemo1.pc, 12.3.1Opens a new window
CPPDEMO2, F.1Opens a new window, F.1Opens a new window
cppdemo2.pc, 12.3.2Opens a new window
CPPDEMO3, F.1Opens a new window, F.1Opens a new window
cppdemo3.pc, 12.3.3Opens a new window
cursor variable demos, 4.5.7Opens a new window
CV_DEMO, F.1Opens a new window, F.1Opens a new window
cv_demo.pc, 4.5.7.2Opens a new window
cv_demo.sql, 4.5.7.1Opens a new window
default drive, F.4Opens a new window
described, F.1Opens a new window
EMPCLASS, F.1Opens a new window, F.1Opens a new window
extp1.pc, 7.8.2Opens a new window
how to precompile, 2.8Opens a new window, 2.9Opens a new window
LOBDEMO1, F.1Opens a new window, F.1Opens a new window
lobdemo1.pc, 16.6.3Opens a new window
location of, 1.6Opens a new window, F.1Opens a new window
MLTTHRD1, F.1Opens a new window, F.1Opens a new window
NAVDEMO1, F.1Opens a new window, F.1Opens a new window
navdemo1.pc, 17.11Opens a new window
OBJDEMO1, F.1Opens a new window, F.1Opens a new window
ORACA, F.1Opens a new window, F.1Opens a new window
oraca.pc, 9.11.6Opens a new window, 9.11.6Opens a new window
PLSSAM, F.1Opens a new window, F.1Opens a new window
SAMPLE, F.1Opens a new window, F.1Opens a new window
SAMPLE1, F.1Opens a new window, F.1Opens a new window
SAMPLE10, F.1Opens a new window, F.1Opens a new window
sample10.pc, 15.7Opens a new window
SAMPLE11, F.1Opens a new window, F.1Opens a new window
sample11.pc, 4.5.7.2Opens a new window
SAMPLE12, F.1Opens a new window, F.1Opens a new window
sample12.pc, 15.6.20Opens a new window
sample1.pc, 2.8Opens a new window
SAMPLE2, F.1Opens a new window, F.1Opens a new window
sample2.pc, 4.8.5Opens a new window
SAMPLE3, F.1Opens a new window, F.1Opens a new window
sample3.pc, 8.4.5Opens a new window
SAMPLE4, F.1Opens a new window, F.1Opens a new window
sample4.pc, 5.3.5Opens a new window
SAMPLE5, F.1Opens a new window, F.1Opens a new window
sample5.pc, 20.11Opens a new window
SAMPLE6, F.1Opens a new window, F.1Opens a new window
sample6.pc, 13.7.1Opens a new window
SAMPLE7, F.1Opens a new window, F.1Opens a new window
sample7.pc, 13.8.2Opens a new window
SAMPLE8, F.1Opens a new window, F.1Opens a new window
sample8.pc, 13.9.6Opens a new window
SAMPLE9, F.1Opens a new window, F.1Opens a new window
sample9.pc, 7.7.2.1Opens a new window
setting the path, F.4Opens a new window
setting the path for the .pre files, F.5Opens a new window
SQLVCP, F.1Opens a new window, F.1Opens a new window
sqlvcp.pc, 4.4.7Opens a new window
WINSAM, F.1Opens a new window, F.1Opens a new window
sample tables
building, F.2Opens a new window
SAVEPOINT SQL statement, E.72Opens a new window
SAVEPOINT statement, E.72Opens a new window
example of, 3.7Opens a new window
examples, E.72Opens a new window
purpose of, 3.7Opens a new window
savepoints
creating, E.72Opens a new window
definition of, 3.7Opens a new window
uses for, 3.7Opens a new window
when erased, 3.7Opens a new window
scale
definition of, 15.4.2.1Opens a new window, E.77Opens a new window
using sqlprc() to extract, 15.4.2.1Opens a new window
when negative, 15.4.2.1Opens a new window, E.77Opens a new window
Scale
using SQLPRC to extract, E.77Opens a new window
SCHEMA_NAMES OTT parameter, 19.5.2.11Opens a new window
usage, 19.5.6Opens a new window
scope
of a cursor variable, 4.5.1Opens a new window
of DECLARE STATEMENT directive, E.25Opens a new window
of precompiler options, 10.3Opens a new window
of the EXEC ORACLE statement, 10.4.2.2Opens a new window
of WHENEVER statement, 9.9.5Opens a new window
search condition
definition of, 6.3.5Opens a new window
in the WHERE clause, 6.3.5Opens a new window
select descriptor, 15.2.1Opens a new window, 15.2.1Opens a new window
information in, 13.10.2Opens a new window
select list
definition of, 6.3.1Opens a new window
number of items in, 6.3.1Opens a new window
using the free() function for, 15.6.17Opens a new window
using the malloc() function for, 15.6.14Opens a new window
SELECT SQL statement, E.73Opens a new window
select SQLDA
purpose of, 15.1.3Opens a new window
SELECT statement, 6.3.1Opens a new window
clauses available for, 6.3.1.1Opens a new window
embedded SQL examples, E.73Opens a new window
example of, 6.3.1Opens a new window
INTO clause in, 6.3.1Opens a new window
purpose of, 6.3.1Opens a new window
testing, 6.3.1.1Opens a new window
using host arrays in, 8.4Opens a new window
WHERE clause in, 6.3.1Opens a new window
SELECT_ERROR
precompiler option, 6.3.1Opens a new window, 10.5.57Opens a new window, 10.5.58Opens a new window
semantic checking
controlling with the SQLCHECK option, C.2Opens a new window
definition of, C.1Opens a new window
enabling, C.3.1Opens a new window
with the SQLCHECK option, C.1Opens a new window
separate precompilation
guidelines for, 2.5.1Opens a new window
referencing cursors for, 2.5.1.1Opens a new window
restrictions on, 2.5.1.1Opens a new window
specifying MAXOPENCURSORS for, 2.5.1.2Opens a new window
using a single SQLCA with, 2.5.1.3Opens a new window
server
integration with PL/SQL, 7.1.2Opens a new window
session
definition of, 3.3Opens a new window
sessions
beginning, E.16Opens a new window
SET clause
in UPDATE statements, 6.3.3Opens a new window
purpose of, 6.3.3Opens a new window
use of subqueries in, 6.3.3Opens a new window
SET DESCRIPTOR statement, 14.5.4Opens a new window, E.74Opens a new window
SET TRANSACTION statement
example of, 3.10Opens a new window
purpose of, 3.10Opens a new window
READ ONLY parameter in, 3.10Opens a new window
requirements for, 3.10Opens a new window
restrictions on, 3.10Opens a new window
Signal handler
SQL single thread limitation, 9.2Opens a new window
Size of an Integer and ROWID, D.1.5Opens a new window
SQL
benefits of, 1.3Opens a new window
Embedded SQL, 1.3Opens a new window
nature of, 1.3Opens a new window
need for, 1.3Opens a new window
signal handler single thread limitation, 9.2Opens a new window
SQL Communications Area, 9.3.2Opens a new window
SQLCA, 9.7Opens a new window
SQL Descriptor Area
SQLDA, 13.10.1Opens a new window, 15.2.1Opens a new window
SQL directives
CONTEXT USE, 11.4.2.3Opens a new window, E.21Opens a new window
DECLARE DATABASE, E.24Opens a new window
DECLARE STATEMENT, E.25Opens a new window
DECLARE TABLE, E.26Opens a new window
DECLARE TYPE, E.27Opens a new window
TYPE, E.75Opens a new window
VAR, E.77Opens a new window
WHENEVER, E.78Opens a new window
SQL statements
ALLOCATE, E.4Opens a new window
ALLOCATE DESCRIPTOR TYPE, E.5Opens a new window
CACHE FREE ALL, E.6Opens a new window
CALL, 7.7.2.3Opens a new window, E.7Opens a new window
CLOSE, E.8Opens a new window
COMMIT, E.15Opens a new window
concerns when executing, 6.3Opens a new window
CONNECT, E.16Opens a new window
CONTEXT ALLOCATE, E.17Opens a new window, E.17Opens a new window
CONTEXT FREE, E.18Opens a new window, E.18Opens a new window
CONTEXT OBJECT OPTION GET, E.19Opens a new window
CONTEXT OBJECT OPTION SET, E.20Opens a new window
DEALLOCATE DESCRIPTOR, E.22Opens a new window
DELETE, E.28Opens a new window
DESCRIBE, E.29Opens a new window
DESCRIBE DESCRIPTOR, E.30Opens a new window
ENABLE THREADS, E.31Opens a new window
executable versus directive, 2.1.1.1Opens a new window
EXECUTE, E.33Opens a new window
EXECUTE ... END-EXEC, E.32Opens a new window
EXECUTE IMMEDIATE, E.35Opens a new window
FETCH, E.36Opens a new window
FETCH DESCRIPTOR, E.37Opens a new window
for defining and controlling transactions, 3.4Opens a new window
for manipulating a cursor, 6.3Opens a new window, 6.5Opens a new window
FREE, E.38Opens a new window
INSERT, E.40Opens a new window
LOB APPEND, E.41Opens a new window
LOB ASSIGN, E.42Opens a new window
LOB CLOSE, E.43Opens a new window
LOB COPY, E.44Opens a new window
LOB CREATE, E.45Opens a new window
LOB DESCRIBE, E.46Opens a new window
LOB DISABLE BUFFERING, E.47Opens a new window
LOB ENABLE BUFFERING, E.48Opens a new window
LOB ERASE, E.49Opens a new window
LOB FILE CLOSE, E.50Opens a new window
LOB FILE SET, E.51Opens a new window
LOB FLUSH BUFFER, E.52Opens a new window
LOB FREE TEMPORARY, E.53Opens a new window
LOB LOAD, E.54Opens a new window
LOB OPEN, E.55Opens a new window
LOB READ, E.56Opens a new window
LOB TRIM, E.57Opens a new window
LOB WRITE, E.58Opens a new window
OBJECT CREATE, E.59Opens a new window
OBJECT DELETE, E.60Opens a new window
OBJECT DEREF, E.61Opens a new window
OBJECT FLUSH, E.62Opens a new window
OBJECT GET, E.63Opens a new window
OBJECT RELEASE, E.64Opens a new window
OBJECT SET, E.65Opens a new window
OBJECT UPDATE, E.66Opens a new window
OPEN, E.67Opens a new window
OPEN DESCRIPTOR, E.68Opens a new window
optimizing to improve performance, B.5Opens a new window
PREPARE, E.69Opens a new window
REGISTER CONNECT, E.70Opens a new window
ROLLBACK, E.71Opens a new window
rules for executing, B.5Opens a new window
SAVEPOINT, E.72Opens a new window, E.72Opens a new window
SELECT, E.73Opens a new window
SET DESCRIPTOR, E.74Opens a new window
summary of, E.1Opens a new window
types of, 2.1.1.1Opens a new window
UPDATE, E.76Opens a new window
SQL*Forms
display error screen in, 20.8Opens a new window
IAP constants in, 20.8.1Opens a new window
returning values to, 20.8Opens a new window
reverse return code switch in, 20.8Opens a new window
SQL*Plus, 1.3Opens a new window
using to test SELECT statements, 6.3.1.1Opens a new window
versus embedded SQL, 1.3Opens a new window
SQL, dynamic, 2.1.3Opens a new window
SQL_CURSOR, E.4Opens a new window
SQL_SINGLE_RCTX
defined constant, 5.11Opens a new window
definition of, 5.9Opens a new window
sql2oci.h header file, 5.5.4Opens a new window, 5.5.4Opens a new window
sqlald() function
example of using, 15.6.3Opens a new window
purpose of, 15.2.4Opens a new window
syntax for, 15.2.4Opens a new window
sqlaldt() function
see SQLSQLDAAlloc, 5.11Opens a new window
sqlapr.h header file, 5.5.4Opens a new window, 5.5.4Opens a new window
SQLCA, 9.3.2Opens a new window, 9.6Opens a new window
components in, 9.7.3Opens a new window
components set for a PL/SQL block, 9.7.4Opens a new window
declaring, 9.7.1Opens a new window
description of, 9.7Opens a new window
explicit versus implicit checking of, 9.3.2Opens a new window
including multiple times, 5.4.7Opens a new window
overview of, 2.1.11Opens a new window
SQLCABC component in, 9.7.3.2Opens a new window
SQLCAID component in, 9.7.3.1Opens a new window
sqlerrd, 9.7.3.6Opens a new window
sqlerrd[2] component in, 9.7.3.6Opens a new window
sqlerrmc component in, 9.7.3.4Opens a new window
sqlerrml component in, 9.7.3.4Opens a new window
sqlwarn, 9.7.3.7Opens a new window
use in separate precompilations, 2.5.1.3Opens a new window
using more than one, 9.7Opens a new window
using with Oracle Net Services, 9.7Opens a new window
sqlca.h
listing of, 9.7.2Opens a new window
use of SQLCA_STORAGE_CLASS with, 2.5.1.3Opens a new window
sqlca.h header file, 5.5.4Opens a new window
SQLCAID component, 9.7.3.1Opens a new window
SQLCDAFromResultSetCursor(), 5.11Opens a new window
SQLCDAGetCurrent, 5.11Opens a new window
sqlcdat()
see SQLCDAFromResultSetCursor(), 5.11Opens a new window
SQLCHECK option
restrictions on, C.2Opens a new window
what it affects, C.2Opens a new window
SQLCHECK precompiler option, 17.8.6Opens a new window, C.3.1.1Opens a new window, C.3.1.2Opens a new window
SQLCHECK support for objects, 17.8.6Opens a new window
sqlclu() function
example of using, 15.6.17Opens a new window
purpose of, 15.6.17Opens a new window
syntax for, 15.6.17Opens a new window
sqlclut() function
see SQLSQLDAFree(), 5.11Opens a new window
sqlcode
component in SQLCA, 9.3.2Opens a new window, 9.6.1Opens a new window
SQLCODE
with MODE=ANSI, 10.5.37Opens a new window
SQLCODE status variable
declaring, 9.5Opens a new window
when declared with the SQLCA, 9.5Opens a new window
when used, 9.5Opens a new window
sqlcpr.h, 9.8Opens a new window
sqlcpr.h header file, 5.5.4Opens a new window
sqlcurt() function
see SQLDAToResultSetCursor(), 5.11Opens a new window
SQLDA
bind versus select, 13.10.3Opens a new window
C variable in, 15.3.9Opens a new window
definition of, 13.10.3Opens a new window
F variable in, 15.3.6Opens a new window
I variable in, 15.3.5Opens a new window
information stored in, 13.10.3Opens a new window
L variable in, 15.3.3Opens a new window
M variable in, 15.3.8Opens a new window
N variable in, 15.3.1Opens a new window
purpose of, 13.10.1Opens a new window
S variable in, 15.3.7Opens a new window
struct, contents of, 15.2.3Opens a new window
structure of, 15.3Opens a new window
T variable in, 15.3.4Opens a new window
use in dynamic SQL method 4, 15.2.1Opens a new window
V variable in, 15.3.2Opens a new window
X variable in, 15.3.10Opens a new window
Y variable in, 15.3.11Opens a new window
Z variable in, 15.3.12Opens a new window
sqlda.h, 15.1.3Opens a new window
SQLDAToResultSetCursor(), 5.11Opens a new window
SQLEnvGet function in SQLLIB, 5.9.1Opens a new window
SQLEnvGet(), 5.11Opens a new window
sqlerrd
component, 9.6.4Opens a new window, 9.7.3.6Opens a new window
sqlerrd[2] component, 9.6.3Opens a new window, 9.7.3.6Opens a new window
returns N or rows fetched, 8.4.3Opens a new window
use with data manipulation statements, 8.4.2Opens a new window
sqlerrm
component in the SQLCA, 9.3.2Opens a new window
sqlerrmc component, 9.7.3.4Opens a new window
sqlerrml component, 9.7.3.4Opens a new window
SQLERROR
WHENEVER directive condition, E.78Opens a new window
SQLERROR condition
in the WHENEVER statement, 9.9.1.2Opens a new window
meaning of, 9.9.1.2Opens a new window
SQLErrorGetText(), 5.11Opens a new window
SQLExtProcError(), 5.11Opens a new window, 7.8.3Opens a new window
sqlglm(), 9.8Opens a new window
sqlglm() function, 9.8Opens a new window, 9.8Opens a new window
example of using, 9.8Opens a new window
parameters of, 9.8Opens a new window
sqlglmt()
see SQLErrorGetText, 5.11Opens a new window
sqlgls() function, 9.10Opens a new window
example of use, 4.4.7Opens a new window
sample program for, 9.10.2Opens a new window
see SQLLIB
function SQLStmGetText, 4.4.7Opens a new window
sqlglst() function
see SQLStmtGetText, 5.11Opens a new window
sqlld2() function, 5.12.1.3Opens a new window
sqlld2t() function
see SQLLDAGetName, 5.11Opens a new window
SQLLDAGetName, 5.11Opens a new window
sqlldat() function
see SQLCDAGetCurrent, 5.11Opens a new window
SQLLIB
and embedded SQL, 2.1.2Opens a new window
extensions for OCI interoperability, 5.8Opens a new window
function
SQLCDAFromResultSetCursor, 5.11Opens a new window
function SQLCDAGetCurrent, 5.11Opens a new window
function SQLColumnNullCheck, 5.11Opens a new window
function SQLDAFree, 5.11Opens a new window
function SQLDAToResultSetCursor, 5.11Opens a new window
function SQLEnvGet, 5.9.1Opens a new window, 5.11Opens a new window
function SQLErrorGetText, 5.11Opens a new window
function SQLExtProcError, 5.11Opens a new window, 7.8.3Opens a new window
function SQLLDAGetName, 5.11Opens a new window
function SQLNumberPrecV6, 5.11Opens a new window
function SQLNumberPrecV7, 5.11Opens a new window
function SQLRowidGet, 5.11Opens a new window
function SQLStmtGetText(), 5.11Opens a new window
function SQLSvcCtxGet, 5.9.2Opens a new window, 5.11Opens a new window
function SQLVarcharGetLength, 4.4.6Opens a new window
new names for public functions, 5.11Opens a new window
SQLLIB function
SQLSQLDAAlloc, 5.11Opens a new window
SQLVarcharGetLength, 5.11Opens a new window
sqlnul() function
example of using, 15.4.3Opens a new window
purpose of, 15.4.3Opens a new window
syntax for, 15.4.3Opens a new window
use of with T variable, 15.3.4Opens a new window
sqlnult() function
see SQLColumnNullCheck(), 5.11Opens a new window
SQLNumberPrecV6, 5.11Opens a new window
SQLNumberPrecV7, 5.11Opens a new window
sqlpr2() function, 15.4.2.1Opens a new window
sqlpr2t() function
see SQLNumberPrecV7, 5.11Opens a new window
sqlprc() function, 15.4.2.1Opens a new window, 15.4.2.1Opens a new window
sqlprct() function
see SQLNumberPrecV6, 5.11Opens a new window
SQLRowidGet(), 5.11Opens a new window
SQLSQLDAAlloc, 5.11Opens a new window
SQLSQLDAFree(), 5.11Opens a new window
SQLSTATE
class codes, 9.4.2Opens a new window
declaring, 9.4.1Opens a new window
mapping to Oracle errors, 9.4.2Opens a new window
status codes, 9.4.2Opens a new window
status variable, 9.3.1Opens a new window, 9.4Opens a new window
using, 9.4.3Opens a new window
values, 9.4.2Opens a new window
with MODE=ANSI, 10.5.37Opens a new window
SQLStmtGetText, 5.11Opens a new window
SQLStmtGetText() function, F.1Opens a new window
SQLSvcCtxGet function in SQLLIB, 5.9.2Opens a new window
SQLSvcCtxGet(), 5.11Opens a new window
SQLVarcharGetLength, 5.11Opens a new window
sqlvcp() function, F.1Opens a new window
sqlvcp() function, see SQLLIB
function SQLVarcharGetLength, 4.4.6Opens a new window
sqlvcpt() function
see SQLVarcharGetLength, 5.11Opens a new window
sqlwarn
flag, 9.7.3.7Opens a new window
SQLWARNING
WHENEVER directive condition, E.78Opens a new window
SQLWARNING condition
in the WHENEVER statement, 9.9.1.1Opens a new window
meaning of, 9.9.1.1Opens a new window
Standard Header Files, D.1.1Opens a new window
statement-level rollback
description of, 3.8.1Opens a new window
to break deadlocks, 3.8.1Opens a new window
status codes
meaning of, 9.6.1Opens a new window
status variables, 9.3.1Opens a new window
STOP action
in the WHENEVER statement, 9.9.2.6Opens a new window
of WHENEVER directive, E.78Opens a new window
result of, 9.9.2.6Opens a new window
stored procedures
program example, 7.7.2.1Opens a new window
stored subprograms
calling, 7.7.2.1Opens a new window
creating, 7.7.1Opens a new window
packaged versus standalone, 7.7Opens a new window
stored versus inline, 7.7Opens a new window
STRING datatype, 4.1.2.5Opens a new window
string host variables
declaring, 5.1.4Opens a new window
Struct Component Alignment, D.1.4Opens a new window
structs
array of, 8.10Opens a new window
as host variables, 4.8Opens a new window
C, using, 17.12Opens a new window
for collection object types, 18.2Opens a new window
generating C structs for a REF, 17.13.1Opens a new window
pointers as host variables, 4.9.3Opens a new window
structs (structures)
cannot be nested, 4.8.3Opens a new window
structures (structs)
nesting not permitted for host, 4.8.3Opens a new window
subqueries
definition of, 6.3.2.1Opens a new window
example of, 6.3.2.1Opens a new window, 6.3.3Opens a new window
uses for, 6.3.2.1Opens a new window
using in the SET clause, 6.3.3Opens a new window
using in the VALUES clause, 6.3.2.1Opens a new window
symbols
defining, 2.4.1Opens a new window
syntax checking
controlling with the SQLCHECK option, C.2Opens a new window
definition of, C.1Opens a new window
syntax diagram
description of, E.3Opens a new window
how to read, E.3Opens a new window
how to use, E.3Opens a new window
symbols used in, E.3Opens a new window
syntax, embedded SQL, 2.1.2Opens a new window
SYS_INCLUDE
system header files in C++, 12.2.4Opens a new window
SYS_INCLUDE precompiler option, 10.5.59Opens a new window
SYS_INCLUDE, INCLUDE Precompiler Options, 10.2.1Opens a new window
system configuration file, 10.2.3Opens a new window
System Configuration File, D.1.10Opens a new window
system failure
effect on transactions, 3.5Opens a new window
System Global Area (SGA), 7.7Opens a new window
system header files
specifying the location of, 12.2.4Opens a new window
system-specific Oracle documentation, 1.8.11Opens a new window, 2.6Opens a new window, 3.2.2Opens a new window, 5.4.4Opens a new window, 5.12.1.4Opens a new window, 20Opens a new window
system-specific reference, 4.1.2.3Opens a new window, 10.1.1Opens a new window, 10.2.2Opens a new window, 10.5.29Opens a new window, 10.5.59Opens a new window

T

TAOpens a new window  TEOpens a new window  THOpens a new window  TIOpens a new window  TOOpens a new window  TROpens a new window  TUOpens a new window  TWOpens a new window  TYOpens a new window 
T variable in SQLDA
how value is set, 15.3.4Opens a new window
purpose of, 15.3.4Opens a new window
table locks
acquiring with LOCK TABLE, 3.11.2Opens a new window
effect of, 3.11.2Opens a new window
row share, 3.11.2Opens a new window
when released, 3.11.2Opens a new window
tables
inserting rows into, E.40Opens a new window
nested, 18.1.1Opens a new window
updating rows in, E.76Opens a new window
terminal
encoding scheme, 4.10Opens a new window
termination, program
normal versus abnormal, 3.9Opens a new window
threads, E.17Opens a new window
allocating context, 11.4.2.2Opens a new window, E.17Opens a new window
enabling, 11.4.2.1Opens a new window, E.31Opens a new window
freeing context, 11.4.2.4Opens a new window, E.18Opens a new window
use context, 11.4.2.3Opens a new window
THREADS
precompiler option, 10.5.60Opens a new window, 11.4.1Opens a new window
TIMESTAMP datatype, 4.1.3.3Opens a new window
TIMESTAMP WITH LOCAL TIME ZONE datatype, 4.1.3.5Opens a new window
TIMESTAMP WITH TIME ZONE datatype, 4.1.3.4Opens a new window
TO clause
of ROLLBACK statement, E.71Opens a new window
TO SAVEPOINT clause
in ROLLBACK statement, 3.8Opens a new window
purpose of, 3.8Opens a new window
restriction on, 3.8Opens a new window
Toolset
Oracle, 20.5Opens a new window
trace facility
function of, B.5.2Opens a new window
using to improve performance, B.5.2Opens a new window
transaction processing
overview of, 2.1.10Opens a new window
statements used for, 2.1.10Opens a new window
transaction processing monitor, 5.12Opens a new window
transactions
committing, E.15Opens a new window
contents of, 2.1.10Opens a new window, 3.5Opens a new window
definition of, 2.1.10Opens a new window
description of, 3.4Opens a new window
distributed, E.71Opens a new window
failure during, 3.5Opens a new window
guarding databases with, 3.4Opens a new window
guidelines for, 3.14.1Opens a new window
how to begin, 3.5Opens a new window
how to end, 3.5Opens a new window
making permanent, 3.6Opens a new window
read-only, 3.10Opens a new window
rolling back, E.71Opens a new window
subdividing with savepoints, 3.7Opens a new window
terminating, 3.6Opens a new window
undoing, 3.8Opens a new window
undoing parts of, 3.7Opens a new window
when rolled back automatically, 3.5Opens a new window, 3.8Opens a new window
transient copies of objects, 17.3.1Opens a new window
transient objects, 17.3.1Opens a new window
TRANSITIVE OTT parameter, 19.5.2.12Opens a new window
truncated values
detecting, 6.2Opens a new window, 7.4.2Opens a new window
truncation error
when generated, 6.2.5Opens a new window
tuning, performance, B.1Opens a new window
two-task
linking, 2.6Opens a new window
type checking at runtime, 17.8.7Opens a new window
TYPE directive
examples, E.75Opens a new window
type inheritance, 17.1.3Opens a new window
example, 17.10Opens a new window
IS OF type operator, 17.1.3Opens a new window
example, 17.1.3Opens a new window, 17.1.3Opens a new window
TREAT operator, 17.1.3Opens a new window
example, 17.1.3Opens a new window, 17.1.3Opens a new window
TYPE SQL directive, E.75Opens a new window
TYPE_CODE
precompiler option, 10.5.61Opens a new window

U

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

V

V7Opens a new window  VAOpens a new window  VEOpens a new window  VIOpens a new window  VMOpens a new window 
V variable in SQLDA
how value is set, 15.3.2Opens a new window
purpose of, 15.3.2Opens a new window
V7
value of DBMS option, 10.5.15Opens a new window, 10.5.16Opens a new window
VALUES clause
in INS, 6.3.2Opens a new window
of embedded SQL INSERT statement, E.40Opens a new window
of INSERT statement, E.40Opens a new window
use of subqueries in, 6.3.2.1Opens a new window
VAR directive
examples, E.77Opens a new window
VAR SQL directive, E.77Opens a new window
VAR statement
syntax for, 5.3.1Opens a new window, 5.3.2Opens a new window
VARCHAR
arrays of, 8.2Opens a new window
VARCHAR datatype, 4.1.2.8Opens a new window
VARCHAR precompiler option, 10.5.65Opens a new window
VARCHAR pseudotype
requirements for using with PL/SQL, 7.3.3Opens a new window
VARCHAR variables
advantages of, 4.4.1Opens a new window
declaring, 4.4.1Opens a new window
length member in, 4.4.1Opens a new window
must be passed to a function by reference, 4.4.5Opens a new window
specifying the length of, 4.4.1Opens a new window
structure of, 4.4.1Opens a new window
using macros to define length of, 5.4.1Opens a new window
versus character arrays, 5.1.4.2Opens a new window
VARCHAR2 datatype, 4.1.2.1Opens a new window, 5.3.3Opens a new window
variables, 2.1.5Opens a new window
cursor, 4.5Opens a new window
host, 18.2.1Opens a new window
indicator, 18.2.1Opens a new window
VARNUM datatype, 4.1.2.6Opens a new window
VARRAW datatype, 4.1.2.12Opens a new window
varrays
creation, 18.1.2Opens a new window
varying length arrays, 18.1.2Opens a new window
VERSION precompiler option, 10.5.66Opens a new window, 17.8.1Opens a new window
views
inserting rows into, E.40Opens a new window
updating rows in, E.76Opens a new window
VMS
linking a precompiler application, 1.8.11Opens a new window

W

WAOpens a new window  WHOpens a new window  WIOpens a new window  WOOpens a new window 
warning flags
use in error reporting, 9.6.2Opens a new window
WHENEVER directive
examples, E.78Opens a new window
WHENEVER SQL directive, E.78Opens a new window
WHENEVER statement
automatic checking of SQLCA with, 9.9.1Opens a new window
CONTINUE action in, 9.9.2.1Opens a new window
DO action in, 9.9.2.2Opens a new window
DO BREAK action in, 9.9.2.3Opens a new window
DO CONTINUE action in, 9.9.2.4Opens a new window
examples of, 9.9.3Opens a new window
GOTO action in, 9.9.2.5Opens a new window
guidelines for, 9.9.6Opens a new window
maintaining addressability for, 9.9.6.4Opens a new window
NOT FOUND condition in, 9.9.1.3Opens a new window
overview of, 2.1.11Opens a new window
scope of, 9.9.5Opens a new window
SQLERROR condition in, 9.9.1.2Opens a new window
SQLWARNING condition in, 9.9.1.1Opens a new window
STOP action in, 9.9.2.6Opens a new window
use in user exits, 20.8.2Opens a new window
using to avoid infinite loops, 9.9.6.3Opens a new window
using to handle end-of-data conditions, 9.9.6.2Opens a new window
where to place, 9.9.6.1Opens a new window
WHERE clause
host arrays in, 8.9Opens a new window
if omitted, 6.3.5Opens a new window
in DELETE statements, 6.3.4Opens a new window
in SELECT statements, 6.3.1Opens a new window
in UPDATE statements, 6.3.3Opens a new window
purpose of, 6.3.5Opens a new window
search condition in, 6.3.5Opens a new window
WHERE CURRENT OF clause
CURRENT OF clause, 6.9Opens a new window
WITH HOLD
clause of DECLARE CURSOR statement, 6.5.1Opens a new window
WORK option
of COMMIT statement, E.15Opens a new window
of ROLLBACK statement, E.71Opens a new window

X

XAOpens a new window 
X variable in SQLDA
how value is set, 15.3.10Opens a new window
purpose of, 15.3.10Opens a new window
XA interface, 5.12Opens a new window
X/Open, 5.12Opens a new window
application development, 5.12Opens a new window

Y

Y variable in SQLDA
how value is set, 15.3.11Opens a new window
purpose of, 15.3.11Opens a new window

Z

Z variable in SQLDA
how value is set, 15.3.12Opens a new window
purpose of, 15.3.12Opens a new window
Previous PageOpens a new window
Page 35 of 35
Next Page