Index

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