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 : Use PL/SQL to Improve Performance of IO-Intensive SQL
  • reducing by calling PL/SQL in SQL : Call PL/SQL Functions in SQL to Reduce I/O
• identifiers
• • (see naming)
  • Identifiers
  • Scope and Visibility
  • precedence in cursors : Identifier Precedence in a Cursor
  • qualified : Qualified identifiers
  • savepoints : (see savepoints)
• identity, object : Identity
• IF statements : Conditional Control Statements
• • ELSE keyword : The IF-THEN-ELSE Combination
  • ELSIF keyword : The IF-ELSIF Combination
  • ELSIF statement : Structured Code and Other Best Practices
  • exception handlers as : Exception Handler as IF Statement
  • formatting : Formatting IF Statements
  • nested : Nested IF Statements
  • replacing DECODE function : Replacing DECODEs with IF Statements
  • using whitespace in : Revealing Logical Structure with Indentation
• implicit conversion : Conversion Functions
• implicit cursors
• • (see also cursors)
  • Standardize Your PL/SQL Development Environment
  • Types of Cursors
  • Implicit Cursors
  • Explicit Cursors
  • attributes to
  • • Cursor Attributes
    • Implicit SQL Cursor Attributes
  • SELECT INTO from : SELECT INTO from an Implicit Cursor
  • vulnerability to data errors : Vulnerability to data errors
• implicit datatype conversion : Implicit data conversions
• IN mode : IN mode
• • stored functions and : Requirements for Stored Functions in SQL
• IN OUT parameter : Work with local copies
• IN OUT parameters
• • The IN OUT mode
  • Assign Values to All OUT and IN OUT Parameters
  • external procedure mappings : Datatype Conversion
  • in functions : Do not use OUT and IN OUT parameters
  • INDICATOR property for : INDICATOR property
• IN OUT parameters, function : Structured Code and Other Best Practices
• IN parameters : Work with local copies
• index, FOR loop : Structured Code and Other Best Practices
• index, table
• • (see also tables)
  • Characteristics of PL/SQL Tables
  • Defining the Table TYPE
  • Referencing fields of record elements in PL/SQL tables
• index-by tables
• • (see also collections)
  • Types of Collections
  • Use Index-By Tables of Records and Objects
  • adding/removing elements of : Adding and Removing Elements
  • assigning values to elements : Assigning Values to Elements: Index (Subscript) Considerations
  • initializing : Initializing Collection Variables
• indexes, ROWID datatype for : The ROWID datatype
• INDICATOR property
• • Datatype Conversion
  • INDICATOR property
• infinite loops : The Simple Loop
• • formatting : Formatting Loops
  • WHILE loops : The Infinite WHILE Loop
• information hiding : Information hiding
• inheritance
• • Inheritance
  • modifying persistent objects and : Modifying Persistent Objects
• INITCAP function : The INITCAP function
• initialization section, package, asserting purity level : Asserting Purity Level with Package Initialization Section
• initializing
• • BFILE columns : The BFILENAME function
  • collection variables : Initializing Collection Variables
  • objects : The Need to Initialize
  • packages : Package Initialization
  • records : Record Initialization
• inner tables : Types of Collections
• input, considering case of : Ensure Case Consistency of Parameters
• INSERT statement
• • (see also DML statements)
  • The VARCHAR2 and VARCHAR datatypes
  • PL/SQL Tables and DML Statements
  • THE function with : The THE Pseudo-function
• instances of classes : Classification
• instantiation
• • of objects : PL/SQL usage
  • of program data, storage of : Key Concepts for Program Execution
• INSTEAD OF triggers
• • INSTEAD OF Triggers
  • compiling : Forcing Compilation
• INSTR function
• • The INSTR function
  • The INSTR function
  • Counting Substring Occurrences in Strings
• INSTRB function : The INSTR function
• instsrv utility (Windows) : Step 1: Set Up the Listener
• INTEGER datatype : Use PLS_INTEGER for All Integer Operations
• integers
• • Binary integer datatypes
  • INT subtype : Numeric Subtypes
  • INTEGER subtype : Numeric Subtypes
  • operations on, performance of : Use PLS_INTEGER for All Integer Operations
  • PLS_INTEGER datatype : The PLS_INTEGER datatype
  • SMALLINT subtype : Numeric Subtypes
• interdependencies, package : Creating Packages with Minimal Interdependencies
• internal documentation : (see comments)
• internal LOBs
• • Large object support
  • BFILE datatype versus : Working with BFILEs
• internationalization, NLS character datatypes : NLS Character Datatypes
• INTERVAL procedure : The INTERVAL procedure
• INTO clause
• • (see also FETCH statement)
  • Matching Column List with INTO Clause
  • SELECT INTO from an Implicit Cursor
  • FETCH INTO from an Explicit Cursor
• INVALID_CURSOR exception : Named System Exceptions
• INVALID_NUMBER exception : Named System Exceptions
• invisible characters : (see whitespace)
• IS DANGLING predicate : Adding Complex Data Structures
• is-a relationship : (see inheritance)
• IS_OPEN function
• • The IS_OPEN function
  • The IS_OPEN function
• IS_PARALLEL_SERVER function : The IS_PARALLEL_SERVER function
• IS_ROLE_ENABLED function : The IS_ROLE_ENABLED function
• isolation levels : The SET TRANSACTION Statement
• %ISOPEN cursor attribute : The %ISOPEN Attribute
• %ISOPEN cursor attribute : Opening Cursors
• ISUBMIT procedure : The ISUBMIT procedure
• iterative
• • assignment into rows : Iterative Assignment
  • control structure : (see loops)