
Symbols
| A
| B
| C
| D
| E
| F
| G
| H
| I
| K
| L
| M
| N
| O
| P
| Q
| R
| S
| T
| U
| V
| W
| Y
| Z
Index: I
- I/O
- 
  - output prefix
: 7.3. The Output Prefix 
  - p package output
  
- 
    - 5.2.1. Toggling output from the p package
    - 7.4. Controlling Output from p
  
 
- PLVfile package for
: 5.11. PLVfile: Operating System I/O Manager
  - PLVio package for
: 5.15. PLVio: Input/Output Processing
  - PLVtrc output
: 21.2.1. Directing Output from PLVtrc
  - put_line output
: 16.4.3.2. Output mechanism of put_line
  - standard output
: 12.2.5. Standard Output Target
 
- ID,
foreign keys
: 5.12.4. Looking up the ID
- id function
: 19.6.4. Looking up the ID
- identifiers
- 
  - (see also reserved words)
  - 2.10.5. Anchoring to Public Variables
 
- idisplay procedure
: 8.7. Implementing PLVtab.display
- idx procedure
: 5.8.3. Dumping the DDL
- IF statement
- 
  - A.1.1. Conditional Logic
  - A.2.1. Conditional Logic
  - 3.7. Handling Program Assumptions
 
- ifunc procedure
: 16.4.4.2. Translating data to constant
- implemenations, comparing
: 14.4.1. Comparing Performance of Different Implementations
- implementation of code
: 3.9. Considering Implementation Options
- implicit queries
: 1.6.1.5. Isolate volatile areas of functionality
- inclschema procedure
: 5.8.1. Including the schema
- inclsp procedure
: 5.8.2. Including the storage parameter
- including_schema function
: 5.8.1. Including the schema
- including_sp function
: 5.8.2. Including the storage parameter
- incomplete installation
: 4.4.4. A Warning About Partial Installation 
- incr_indent function
: 16.3.1. Indentation in PLVgen
- increment_and_commit procedure
- 
  - 5.7.3. Performing commits
  - 12.9.3. Clearing the Target
  - 20.1.3. Performing Incremental Commits
 
- inctlg.sql script
- 
  - 18.2.3.3. Examining the catalogue
  - 18.2.4.1. Examining the references
 
- indent function
: 16.3.1. Indentation in PLVgen
- indent_stg function
: 16.4.3.3. Modularization inside put_line 
- indentation
- 
  - 2.2. Using Effective Coding Style for Packages
  - 5.13.1. Package constants
  - in PLVgen package
: 16.3.1. Indentation in PLVgen
  - of generated code
: 16.2.2.3. Changing indentation of generated code
 
- infile function
- 
  - 5.11.9. Reading from a file
  - 13.5.3. The INSTR of PLVFile
 
- init.ora file
: 13.1.1. Enabling File Access in the Oracle Server 
- init_counter procedure
- 
  - 5.7.4. Managing the commit counter
  - 20.1.3.2. Initializing the counter
 
- init_table procedure
- 
  - 5.22.3. Parsing PL/SQL source code
  - 10.3.3. Initializing a Table of Tokens
 
- initialization section, package
- 
  - 1.6.3. The Initialization Section
  - 1.6.5.2. Asserting the purity level of the initialization section
 
- initializing
- 
  - PLVcmt counter
: 20.1.3.2. Initializing the counter
  - source repository
: 12.3.2. Initializing the Source
  - SQL*Plus
: 4.4.2. A PL/Vision Initialization Script for SQL*Plus
  - target repository
  
- 
    - 5.15.6. Managing the target repository
    - 12.5.1. Initializing the Target
  
 
- token table
: 10.3.3. Initializing a Table of Tokens
 
- initline procedure
: 5.15.7. Reading and writing lines
- initsrc procedure
- 
  - 5.15.4. Managing the source repository
  - 12.3.2. Initializing the Source
 
- inittrg procedure
- 
  - 5.15.6. Managing the target repository
  - 12.5.1. Initializing the Target
 
- inline help
: (see comments; help)
- INSERT statement
: 12.5. Managing the Target Repository
- insert_failure exception
: 5.15.1. Package constants and exceptions
- insertitem procedure
: 5.18.3. Modifying list contents 
- install subdirectory
- 
  - 4.3.3. Beginning the Installation
  - 4.6.1. Contents of the install Subdirectory
 
- installing
- 
  - PL/Vision help packages
: 4.4. Installing Online Help for PL/Vision
  - PL/Vision Lite
: 4.3. Installation Instructions
  - windows in packages
: 2.7.2. Designing the Window Interface
 
- INSTR function
- 
  - 10.1.3.4. nth_atomic function
  - 13.5.3. The INSTR of PLVFile
 
- intab procedure
: 21.1.6. Displaying the Log
- integrity
- 
  - 1.3.5. Guaranteeing Transaction Integrity
  - 21.1.5. Rolling Back with PLVlog
 
- interface
- 
  - messages
: (see messages)
  - packages
  
- 
    - 2.5. Constructing the Optimal Interface to Your Package
    - 2.10.3. Simplifying Package Interfaces
  
 
- PLVcmt package
: 5.7. PLVcmt: Commit Processing
  - to SQLERRM function
: 6.4.2. Obtaining the Error Message
  - to foreign key information
: 5.12. PLVfk: Foreign Key Interface
  - to PL/SQL objects
  
- 
    - 5.20. PLVobj: Object Interface
    - 11.  PLVobj: A Packaged Interface to ALL_OBJECTS
  
 
- to PLV_token table
: 5.26. PLVtkn: Token Table Interface
  - top-down design
: 1.3.3. Top-Down Design
  - user
: 3.4. Improving the User Interface
  - window (trace)
: 2.7.2. Designing the Window Interface
 
- interfact
DBMS_SQL package
: 19.4. PLVdyn: A Code Layer over DBMS_SQL
- invalid action codes
: 3.7. Handling Program Assumptions
- INVALID_FILEHANDLE exception
: 13.1.4. Handling UTL_FILE Errors
- INVALID_MODE exception
: 13.1.4. Handling UTL_FILE Errors
- INVALID_OPERATION exception
: 13.1.4. Handling UTL_FILE Errors
- INVALID_PATH exception
- 
  - 13.1.4. Handling UTL_FILE Errors
  - 13.9. Handling File Errors with PLVfile
 
- IS
: (see initialization section, package)
- is_blank function
: 5.6.2. Character type functions
- is_builtin function
- 
  - 5.26.3. Determining type of token 
  - 10.2.2. Determining Token Type
 
- is_datatype function
- 
  - 5.26.3. Determining type of token 
  - 10.2.2. Determining Token Type
 
- is_delimiter function
: 5.16.1. Analyzing PL/SQL string content
- is_digit function
: 5.6.2. Character type functions
- is_exception function
- 
  - 5.26.3. Determining type of token 
  - 10.2.2. Determining Token Type
 
- is_keyword function
- 
  - 5.26.3. Determining type of token 
  - 10.2.2. Determining Token Type
 
- is_letter function
: 5.6.2. Character type functions
- is_made function
: 5.18.2. Creating and destroying lists
- is_nonprinting function
: 5.6.2. Character type functions
- is_oneline_comment function
: 5.16.1. Analyzing PL/SQL string content
- is_other function
: 5.6.2. Character type functions
- is_quote function
: 5.6.2. Character type functions
- is_symbol function
- 
  - 5.26.3. Determining type of token 
  - 10.2.2. Determining Token Type
 
- is_syntax function
- 
  - 5.26.3. Determining type of token 
  - 10.2.2. Determining Token Type
 
- itemin function
: 5.24.4. Analyzing stack contents
Symbols
| A
| B
| C
| D
| E
| F
| G
| H
| I
| K
| L
| M
| N
| O
| P
| Q
| R
| S
| T
| U
| V
| W
| Y
| Z
 
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.