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)

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