Index

Book HomeBook HomeSearch this book

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

Index: I

I/O
I/O-intensive SQL : 25.3.6. Use PL/SQL to Improve Performance of IO-Intensive SQL
reducing by calling PL/SQL in SQL : 25.3.2. Call PL/SQL Functions in SQL to Reduce I/O
identifiers
(see naming)
2.2. Identifiers
15.3.5. Scope and Visibility
precedence in cursors : 6.4.3. Identifier Precedence in a Cursor
qualified : 15.3.5.1. Qualified identifiers
savepoints : (see savepoints)
identity, object : 18.1.4.1. Identity
IF statements : 5.1. Conditional Control Statements
ELSE keyword : 5.1.2. The IF-THEN-ELSE Combination
ELSIF keyword : 5.1.3. The IF-ELSIF Combination
ELSIF statement : 1.7.5. Structured Code and Other Best Practices
exception handlers as : 8.9. Exception Handler as IF Statement
formatting : 3.3.1. Formatting IF Statements
nested : 5.1.4. Nested IF Statements
replacing DECODE function : 17.8.4. Replacing DECODEs with IF Statements
using whitespace in : 3.1.1. Revealing Logical Structure with Indentation
implicit conversion : 14. Conversion Functions
implicit cursors
(see also cursors)
1.7.4. Standardize Your PL/SQL Development Environment
6.2.1. Types of Cursors
6.3.1. Implicit Cursors
6.3.3. Explicit Cursors
attributes to
6.9. Cursor Attributes
6.9.5. Implicit SQL Cursor Attributes
SELECT INTO from : 9.5.2. SELECT INTO from an Implicit Cursor
vulnerability to data errors : 6.3.2.2. Vulnerability to data errors
implicit datatype conversion : 4.2.8.2. Implicit data conversions
IN mode : 15.6.2.1. IN mode
stored functions and : 17.3. Requirements for Stored Functions in SQL
IN OUT parameter : 25.4.3.1. Work with local copies
IN OUT parameters
15.6.2.3. The IN OUT mode
22.7.3. Assign Values to All OUT and IN OUT Parameters
external procedure mappings : 21.4.1. Datatype Conversion
in functions : 22.2.1.1. Do not use OUT and IN OUT parameters
INDICATOR property for : 21.4.3.1. INDICATOR property
IN OUT parameters, function : 1.7.5. Structured Code and Other Best Practices
IN parameters : 25.4.3.1. Work with local copies
index, FOR loop : 1.7.5. Structured Code and Other Best Practices
index, table
(see also tables)
10.2. Characteristics of PL/SQL Tables
10.4.1. Defining the Table TYPE
10.8.1.1. Referencing fields of record elements in PL/SQL tables
index-by tables
(see also collections)
19.1. Types of Collections
25.4.8. Use Index-By Tables of Records and Objects
adding/removing elements of : 19.4.3. Adding and Removing Elements
assigning values to elements : 19.4.2. Assigning Values to Elements: Index (Subscript) Considerations
initializing : 19.4.1. Initializing Collection Variables
indexes, ROWID datatype for : 4.2.3.6. The ROWID datatype
INDICATOR property
21.4.1. Datatype Conversion
21.4.3.1. INDICATOR property
infinite loops : 7.2. The Simple Loop
formatting : 3.3.2. Formatting Loops
WHILE loops : 7.5.1. The Infinite WHILE Loop
information hiding : 18.1.5.1. Information hiding
inheritance
18.1.4.3. Inheritance
modifying persistent objects and : 18.5. Modifying Persistent Objects
INITCAP function : 11.1.4. The INITCAP function
initialization section, package, asserting purity level : 17.5.2. Asserting Purity Level with Package Initialization Section
initializing
BFILE columns : 13.2.1. The BFILENAME function
collection variables : 19.4.1. Initializing Collection Variables
objects : 18.4.1. The Need to Initialize
packages : 16.6. Package Initialization
records : 9.6.2. Record Initialization
inner tables : 19.1. Types of Collections
input, considering case of : 22.7.4. Ensure Case Consistency of Parameters
INSERT statement
(see also DML statements)
4.2.3.2. The VARCHAR2 and VARCHAR datatypes
10.3. PL/SQL Tables and DML Statements
THE function with : 19.5.1. The THE Pseudo-function
instances of classes : 18.1.4.2. Classification
instantiation
of objects : 18.2.2.1. PL/SQL usage
of program data, storage of : 23.1.4. Key Concepts for Program Execution
INSTEAD OF triggers
20.2. INSTEAD OF Triggers
compiling : 20.7.3. Forcing Compilation
INSTR function
C.6.12. The INSTR function
11.1.5. The INSTR function
11.2.4. Counting Substring Occurrences in Strings
INSTRB function : 11.1.5. The INSTR function
instsrv utility (Windows NT) : 21.2.1. Step 1: Set Up the Listener
INTEGER datatype : 25.4.5. Use PLS_INTEGER for All Integer Operations
integers
4.2.1.1. Binary integer datatypes
INT subtype : 4.2.2. Numeric Subtypes
INTEGER subtype : 4.2.2. Numeric Subtypes
operations on, performance of : 25.4.5. Use PLS_INTEGER for All Integer Operations
PLS_INTEGER datatype : 4.2.1.3. The PLS_INTEGER datatype
SMALLINT subtype : 4.2.2. Numeric Subtypes
interdependencies, package : 25.2.4. Creating Packages with Minimal Interdependencies
internal documentation : (see comments)
internal LOBs
1.4.7.6. Large object support
BFILE datatype versus : 4.2.7.7. Working with BFILEs
internationalization, NLS character datatypes : 4.2.6. NLS Character Datatypes
INTERVAL procedure : C.5.3. The INTERVAL procedure
INTO clause
(see also FETCH statement)
6.6.1. Matching Column List with INTO Clause
9.5.2. SELECT INTO from an Implicit Cursor
9.5.3. FETCH INTO from an Explicit Cursor
INVALID_CURSOR exception : 8.3.1. Named System Exceptions
INVALID_NUMBER exception : 8.3.1. Named System Exceptions
invisible characters : (see whitespace)
IS DANGLING predicate : 18.2.3. Adding Complex Data Structures
is-a relationship : (see inheritance)
IS_OPEN function
C.14.9. The IS_OPEN function
C.17.1.6. The IS_OPEN function
IS_PARALLEL_SERVER function : C.16.7. The IS_PARALLEL_SERVER function
IS_ROLE_ENABLED function : C.12.2. The IS_ROLE_ENABLED function
isolation levels : 6.1.4. The SET TRANSACTION Statement
%ISOPEN cursor attribute : 6.9.4. The %ISOPEN Attribute
%ISOPEN cursor attribute : 6.5. Opening Cursors
ISUBMIT procedure : C.5.4. The ISUBMIT procedure
iterative
assignment into rows : 10.6.2. Iterative Assignment
control structure : (see loops)


Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z
The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference