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

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