Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Index: I

%ISOPEN cursor attribute

6.9.4. The %ISOPEN Attribute, Oracle PL/SQL Programming
6.5. Opening Cursors, Oracle PL/SQL Programming

errors: 6.2.6.1. Handling file I/O errors, Oracle Built-in Packages

I/O-intensive SQL: 25.3.6. Use PL/SQL to Improve Performance of IO-Intensive SQL, Oracle PL/SQL Programming

PLVfile package for: 5.11. PLVfile: Operating System I/O Manager, Advanced Oracle PL/SQL Programming with Packages

PLVio package for: 5.15. PLVio: Input/Output Processing, Advanced Oracle PL/SQL Programming with Packages

PLVtrc output: 21.2.1. Directing Output from PLVtrc, Advanced Oracle PL/SQL Programming with Packages

output prefix: 7.3. The Output Prefix , Advanced Oracle PL/SQL Programming with Packages

p package output

5.2.1. Toggling output from the p package, Advanced Oracle PL/SQL Programming with Packages
7.4. Controlling Output from p, Advanced Oracle PL/SQL Programming with Packages

put_line output: 16.4.3.2. Output mechanism of put_line, Advanced Oracle PL/SQL Programming with Packages

reducing by calling PL/SQL in SQL: 25.3.2. Call PL/SQL Functions in SQL to Reduce I/O, Oracle PL/SQL Programming

standard output: 12.2.5. Standard Output Target, Advanced Oracle PL/SQL Programming with Packages

ID, foreign keys: 5.12.4. Looking up the ID, Advanced Oracle PL/SQL Programming with Packages

IF statements

5.1. Conditional Control Statements, Oracle PL/SQL Programming
A.1.1. Conditional Logic, Advanced Oracle PL/SQL Programming with Packages
A.2.1. Conditional Logic, Advanced Oracle PL/SQL Programming with Packages
3.7. Handling Program Assumptions, Advanced Oracle PL/SQL Programming with Packages
ELSE keyword: 5.1.2. The IF-THEN-ELSE Combination, Oracle PL/SQL Programming
ELSIF keyword: 5.1.3. The IF-ELSIF Combination, Oracle PL/SQL Programming
ELSIF statement: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
exception handlers as: 8.9. Exception Handler as IF Statement, Oracle PL/SQL Programming
formatting: 3.3.1. Formatting IF Statements, Oracle PL/SQL Programming
nested: 5.1.4. Nested IF Statements, Oracle PL/SQL Programming
replacing DECODE function: 17.8.4. Replacing DECODEs with IF Statements, Oracle PL/SQL Programming
using whitespace in: 3.1.1. Revealing Logical Structure with Indentation, Oracle PL/SQL Programming

IF-THEN conditional statements, PL/SQL: 6.2.3. Conditionals, Oracle Web Applications

IF-THEN-ELSE conditional statements, PL/SQL: 6.2.3. Conditionals, Oracle Web Applications

IMAP4: 1.3.1. The Internet File System, Oracle Web Applications

IN OUT mode, bind argument: 4.4.3. Argument Modes , Guide to Oracle8i Features

IN OUT parameters

25.4.3.1. Work with local copies, Oracle PL/SQL Programming

15.6.2.3. The IN OUT mode, Oracle PL/SQL Programming

22.7.3. Assign Values to All OUT and IN OUT Parameters, Oracle PL/SQL Programming

INDICATOR property for: 21.4.3.1. INDICATOR property, Oracle PL/SQL Programming

external procedure mappings: 21.4.1. Datatype Conversion, Oracle PL/SQL Programming

in functions

22.2.1.1. Do not use OUT and IN OUT parameters, Oracle PL/SQL Programming
1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

IN mode

15.6.2.1. IN mode, Oracle PL/SQL Programming
bind argument: 4.4.3. Argument Modes , Guide to Oracle8i Features
stored functions and: 17.3. Requirements for Stored Functions in SQL, Oracle PL/SQL Programming

IN parameters: 25.4.3.1. Work with local copies, Oracle PL/SQL Programming

INDICATOR property

21.4.1. Datatype Conversion, Oracle PL/SQL Programming
21.4.3.1. INDICATOR property, Oracle PL/SQL Programming

INIT.ORA initialization file: 2.4. Rules and Restrictions, Guide to Oracle8i Features

INITCAP function: 11.1.4. The INITCAP function, Oracle PL/SQL Programming

INITIALIZE procedure: 10.4.2.1. The DBMS_RANDOM.INITIALIZE procedure, Oracle Built-in Packages

INS column, *_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

INSERT statement

(see also DML statements)
12.5. Managing the Target Repository, Advanced Oracle PL/SQL Programming with Packages
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
6. New Trigger Features in Oracle8i, Guide to Oracle8i Features
4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming
10.3. PL/SQL Tables and DML Statements, Oracle PL/SQL Programming
multiple-row inserts: 2.5.6.1. Using array processing to insert, Oracle Built-in Packages
single-row RETURNING clause: 2.5.7.1. RETURNING from a single-row insert, Oracle Built-in Packages
THE function with: 19.5.1. The THE Pseudo-function, Oracle PL/SQL Programming

INSTANCE_NUM attribute, database-level event: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features

INSTEAD OF triggers

6.1. Triggers on Nested Table View Columns, Guide to Oracle8i Features
20.2. INSTEAD OF Triggers, Oracle PL/SQL Programming
compiling: 20.7.3. Forcing Compilation, Oracle PL/SQL Programming

INSTR function

10.1.3.4. nth_atomic function, Advanced Oracle PL/SQL Programming with Packages
13.5.3. The INSTR of PLVFile, Advanced Oracle PL/SQL Programming with Packages
8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.2.5. The DBMS_LOB.INSTR function, Oracle Built-in Packages
C.6.12. The INSTR function, Oracle PL/SQL Programming
11.1.5. The INSTR function, Oracle PL/SQL Programming
11.2.4. Counting Substring Occurrences in Strings, Oracle PL/SQL Programming

INSTRB function: 11.1.5. The INSTR function, Oracle PL/SQL Programming

INTEGER datatype: 25.4.5. Use PLS_INTEGER for All Integer Operations, Oracle PL/SQL Programming

INTERVAL procedure

13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
13.2.6.2. The DBMS_JOB.INTERVAL procedure, Oracle Built-in Packages
C.5.3. The INTERVAL procedure, Oracle PL/SQL Programming

INTO clause

(see also FETCH statement)
1.3.4. Bulk Binds and Collects (Chapter 5, Bulking Up with PL/SQL 8.1), Guide to Oracle8i Features
4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
6.6.1. Matching Column List with INTO Clause, Oracle PL/SQL Programming
9.5.2. SELECT INTO from an Implicit Cursor, Oracle PL/SQL Programming
9.5.3. FETCH INTO from an Explicit Cursor, Oracle PL/SQL Programming
EXECUTE IMMEDIATE statement: 4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features

INVALID_CURSOR exception: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

INVALID_FILEHANDLE exception: 13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages

INVALID_MODE exception: 13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages

INVALID_NUMBER exception: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

INVALID_OPERATION exception: 13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages

INVALID_PATH exception

13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages
13.9. Handling File Errors with PLVfile, Advanced Oracle PL/SQL Programming with Packages

IP_ADDRESS attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features

IP_ADDRESS datatype: 7.4.1.2. Querying the environment, Oracle Web Applications

IS: (see initialization section, package)

IS DANGLING predicate: 18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming

IS keyword: 1.3.2. Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? ), Guide to Oracle8i Features

ISTEMPORARY procedure, DBMS_LOB package: 7.5.2.3. ISTEMPORARY: Is it a temporary LOB?, Guide to Oracle8i Features

ISUBMIT procedure

13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
13.2.5.2. The DBMS_JOB.ISUBMIT procedure, Oracle Built-in Packages
C.5.4. The ISUBMIT procedure, Oracle PL/SQL Programming

IS_LOCATOR function, UTL_COLL package: 7.4. UTL_COLL: Using Collection Locators, Guide to Oracle8i Features

IS_OPEN function

C.14.9. The IS_OPEN function, Oracle PL/SQL Programming
C.17.1.6. The IS_OPEN function, Oracle PL/SQL Programming

IS_OPEN function (DBMS_SQL package)

2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.2.2. The DBMS_SQL.IS_OPEN function, Oracle Built-in Packages

IS_OPEN function (UTL_FILE)

6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
6.2.2.2. The UTL_FILE.IS_OPEN function, Oracle Built-in Packages
tips about: 6.2.6.5. You closed what?, Oracle Built-in Packages

IS_PARALLEL_SERVER function

10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function, Oracle Built-in Packages
C.16.7. The IS_PARALLEL_SERVER function, Oracle PL/SQL Programming

IS_ROLE_ENABLED function

11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.3.1. The DBMS_SESSION.IS_ROLE_ENABLED function, Oracle Built-in Packages
C.12.2. The IS_ROLE_ENABLED function, Oracle PL/SQL Programming

IS_SERVERERROR attribute, database-level event: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features

I_AM_A_REFRESH function

14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function, Oracle Built-in Packages

Informix: 1.2. And Then There's Java, Guide to Oracle8i Features

Institute for Study Conduction: 1.3.5. Encapsulating Access to the Built-in Packages, Oracle Built-in Packages

Intel: 1.2.2.2. Developers must know too many platforms, Oracle Web Applications

Internet Explorer: 2.2.4. The Web Browser, Oracle Web Applications

Internet File System (iFS)

1.1. What's in Oracle8i Release 8.1?, Guide to Oracle8i Features
1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
1.3.1. The Internet File System, Oracle Web Applications

Internet technology: (see web technologies)

InternetLite

1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
1.3.8. InternetLite, Oracle Web Applications

id function: 19.6.4. Looking up the ID, Advanced Oracle PL/SQL Programming with Packages

identifiers

precedence in cursors: 6.4.3. Identifier Precedence in a Cursor, Oracle PL/SQL Programming
qualified: 15.3.5.1. Qualified identifiers, Oracle PL/SQL Programming
savepoints: (see savepoints)

identity, object: 18.1.4.1. Identity , Oracle PL/SQL Programming

idisplay procedure: 8.7. Implementing PLVtab.display, Advanced Oracle PL/SQL Programming with Packages

idx procedure: 5.8.3. Dumping the DDL, Advanced Oracle PL/SQL Programming with Packages

ifunc procedure: 16.4.4.2. Translating data to constant, Advanced Oracle PL/SQL Programming with Packages

il2tab2.sp : 6.2.7.1. Enhancing UTL_FILE.GET_LINE, Oracle Built-in Packages

imagemap, WebDB dashboard: 3.1.3.1. User-uploaded content, Oracle Web Applications

images library, WebDB: 3.1.2.3. Building shared components, Oracle Web Applications

immediate execution: 2.3.3.1. The DBMS_SQL.PARSE procedure, Oracle Built-in Packages

immediate fetching: 2.3.7.2. The DBMS_SQL.EXECUTE_AND_FETCH function, Oracle Built-in Packages

implemenations, comparing: 14.4.1. Comparing Performance of Different Implementations, Advanced Oracle PL/SQL Programming with Packages

implementation of code: 3.9. Considering Implementation Options, Advanced Oracle PL/SQL Programming with Packages

implicit conversion: 14. Conversion Functions, Oracle PL/SQL Programming

implicit cursors

(see also cursors)

1.7.4. Standardize Your PL/SQL Development Environment, Oracle PL/SQL Programming

6.2.1. Types of Cursors, Oracle PL/SQL Programming

6.3.1. Implicit Cursors, Oracle PL/SQL Programming

6.3.3. Explicit Cursors, Oracle PL/SQL Programming

SELECT INTO from: 9.5.2. SELECT INTO from an Implicit Cursor, Oracle PL/SQL Programming

attributes to

6.9. Cursor Attributes, Oracle PL/SQL Programming
6.9.5. Implicit SQL Cursor Attributes, Oracle PL/SQL Programming

vulnerability to data errors: 6.3.2.2. Vulnerability to data errors, Oracle PL/SQL Programming

implicit datatype conversion: 4.2.8.2. Implicit data conversions, Oracle PL/SQL Programming

implicit queries: 1.6.1.5. Isolate volatile areas of functionality, Advanced Oracle PL/SQL Programming with Packages

import/export: (see master sites, instantiation)

in-doubt transactions

advice about: 4.2.2. Advising Oracle About In-Doubt Transactions, Oracle Built-in Packages
commitment: 4.2.3.2. The DBMS_TRANSACTION.COMMIT_COMMENT procedure, Oracle Built-in Packages
purging: 4.2.6.1. The DBMS_TRANSACTION.PURGE_MIXED procedure, Oracle Built-in Packages
rollback: 4.2.4.2. The DBMS_TRANSACTION.ROLLBACK_FORCE procedure, Oracle Built-in Packages

inclschema procedure: 5.8.1. Including the schema, Advanced Oracle PL/SQL Programming with Packages

inclsp procedure: 5.8.2. Including the storage parameter, Advanced Oracle PL/SQL Programming with Packages

including_schema function: 5.8.1. Including the schema, Advanced Oracle PL/SQL Programming with Packages

including_sp function: 5.8.2. Including the storage parameter, Advanced Oracle PL/SQL Programming with Packages

inclusive or: (see OR bit operation)

incomplete installation: 4.4.4. A Warning About Partial Installation , Advanced Oracle PL/SQL Programming with Packages

incr_indent function: 16.3.1. Indentation in PLVgen, Advanced Oracle PL/SQL Programming with Packages

increment_and_commit procedure

5.7.3. Performing commits, Advanced Oracle PL/SQL Programming with Packages
12.9.3. Clearing the Target, Advanced Oracle PL/SQL Programming with Packages
20.1.3. Performing Incremental Commits, Advanced Oracle PL/SQL Programming with Packages

inctlg.sql script

18.2.3.3. Examining the catalogue, Advanced Oracle PL/SQL Programming with Packages
18.2.4.1. Examining the references, Advanced Oracle PL/SQL Programming with Packages

indent function: 16.3.1. Indentation in PLVgen, Advanced Oracle PL/SQL Programming with Packages

indent_stg function: 16.4.3.3. Modularization inside put_line , Advanced Oracle PL/SQL Programming with Packages

indentation

2.2. Using Effective Coding Style for Packages, Advanced Oracle PL/SQL Programming with Packages
5.13.1. Package constants, Advanced Oracle PL/SQL Programming with Packages
in PLVgen package: 16.3.1. Indentation in PLVgen, Advanced Oracle PL/SQL Programming with Packages
of generated code: 16.2.2.3. Changing indentation of generated code, Advanced Oracle PL/SQL Programming with Packages

index wizard, WebDB: 3.1.2.1. Building database objects, Oracle Web Applications

index, FOR loop: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

index, table

(see also tables)
10.2. Characteristics of PL/SQL Tables, Oracle PL/SQL Programming
10.4.1. Defining the Table TYPE, Oracle PL/SQL Programming
10.8.1.1. Referencing fields of record elements in PL/SQL tables, Oracle PL/SQL Programming

index-by tables

(see also collections)

6.2.6. Index-by Tables (Arrays), Oracle Web Applications

4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features

5.1. Context-Switching Problem Scenarios, Guide to Oracle8i Features

19.1. Types of Collections, Oracle PL/SQL Programming

25.4.8. Use Index-By Tables of Records and Objects, Oracle PL/SQL Programming

adding/removing elements of: 19.4.3. Adding and Removing Elements, Oracle PL/SQL Programming

array processing and

2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages

2.5.6. Array Processing with DBMS_SQL, Oracle Built-in Packages

copying: 2.5.6.5. Using array processing in dynamic PL/SQL , Oracle Built-in Packages

assigning values to elements: 19.4.2. Assigning Values to Elements: Index (Subscript) Considerations, Oracle PL/SQL Programming

dynamic SQL blocks and: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages

initializing: 19.4.1. Initializing Collection Variables, Oracle PL/SQL Programming

index_row variable, FORALL statement: 5.2. Bulk DML with the FORALL Statement, Guide to Oracle8i Features

indexes

ROWID datatype for: 4.2.3.6. The ROWID datatype, Oracle PL/SQL Programming
space utilization: 12.1. DBMS_SPACE: Obtaining Space Information, Oracle Built-in Packages

indirect referencing

4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features
example of: 2.5.5. Indirect Referencing in PL/SQL, Oracle Built-in Packages

infile function

5.11.9. Reading from a file, Advanced Oracle PL/SQL Programming with Packages
13.5.3. The INSTR of PLVFile, Advanced Oracle PL/SQL Programming with Packages

infinite loops: 7.2. The Simple Loop, Oracle PL/SQL Programming

WHILE loops: 7.5.1. The Infinite WHILE Loop, Oracle PL/SQL Programming
formatting: 3.3.2. Formatting Loops, Oracle PL/SQL Programming

information hiding

18.1.5.1. Information hiding, Oracle PL/SQL Programming
PL/SQL packages: 6.3.5. Information Hiding, Oracle Web Applications

inheritance

18.1.4.3. Inheritance , Oracle PL/SQL Programming
modifying persistent objects and: 18.5. Modifying Persistent Objects, Oracle PL/SQL Programming

init.ora file: 13.1.1. Enabling File Access in the Oracle Server , Advanced Oracle PL/SQL Programming with Packages

init_counter procedure

5.7.4. Managing the commit counter, Advanced Oracle PL/SQL Programming with Packages
20.1.3.2. Initializing the counter, Advanced Oracle PL/SQL Programming with Packages

init_info procedure: 10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure, Oracle Built-in Packages

init_table procedure

5.22.3. Parsing PL/SQL source code, Advanced Oracle PL/SQL Programming with Packages
10.3.3. Initializing a Table of Tokens, Advanced Oracle PL/SQL Programming with Packages

initcur procedure: 2.4.4. Minimizing Memory for Cursors, Oracle Built-in Packages

initialization parameters, returning: 10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function , Oracle Built-in Packages

initialization section, package

1.6.3. The Initialization Section, Advanced Oracle PL/SQL Programming with Packages
1.6.5.2. Asserting the purity level of the initialization section, Advanced Oracle PL/SQL Programming with Packages
asserting purity level: 17.5.2. Asserting Purity Level with Package Initialization Section, Oracle PL/SQL Programming

initializing

BFILE columns: 13.2.1. The BFILENAME function, Oracle PL/SQL Programming

PLVcmt counter: 20.1.3.2. Initializing the counter, Advanced Oracle PL/SQL Programming with Packages

SQL*Plus: 4.4.2. A PL/Vision Initialization Script for SQL*Plus, Advanced Oracle PL/SQL Programming with Packages

collection variables: 19.4.1. Initializing Collection Variables, Oracle PL/SQL Programming

objects: 18.4.1. The Need to Initialize, Oracle PL/SQL Programming

packages: 16.6. Package Initialization, Oracle PL/SQL Programming

records: 9.6.2. Record Initialization, Oracle PL/SQL Programming

source repository: 12.3.2. Initializing the Source, Advanced Oracle PL/SQL Programming with Packages

target repository

5.15.6. Managing the target repository, Advanced Oracle PL/SQL Programming with Packages
12.5.1. Initializing the Target, Advanced Oracle PL/SQL Programming with Packages

token table: 10.3.3. Initializing a Table of Tokens, Advanced Oracle PL/SQL Programming with Packages

initline procedure: 5.15.7. Reading and writing lines, Advanced Oracle PL/SQL Programming with Packages

initsrc procedure

5.15.4. Managing the source repository, Advanced Oracle PL/SQL Programming with Packages
12.3.2. Initializing the Source, Advanced Oracle PL/SQL Programming with Packages

inittrg procedure

5.15.6. Managing the target repository, Advanced Oracle PL/SQL Programming with Packages
12.5.1. Initializing the Target, Advanced Oracle PL/SQL Programming with Packages

inline help: (see comments; help)

inner tables: 19.1. Types of Collections, Oracle PL/SQL Programming

input, considering case of: 22.7.4. Ensure Case Consistency of Parameters, Oracle PL/SQL Programming

insert conflicts

(see also uniqueness conflicts)
16. Conflict Resolution, Oracle Built-in Packages

insert_failure exception: 5.15.1. Package constants and exceptions, Advanced Oracle PL/SQL Programming with Packages

insertitem procedure: 5.18.3. Modifying list contents , Advanced Oracle PL/SQL Programming with Packages

insret.sp : 2.5.7.1. RETURNING from a single-row insert, Oracle Built-in Packages

install subdirectory

4.3.3. Beginning the Installation, Advanced Oracle PL/SQL Programming with Packages
4.6.1. Contents of the install Subdirectory, Advanced Oracle PL/SQL Programming with Packages

installing

PL/Vision Lite: 4.3. Installation Instructions, Advanced Oracle PL/SQL Programming with Packages
PL/Vision help packages: 4.4. Installing Online Help for PL/Vision, Advanced Oracle PL/SQL Programming with Packages
windows in packages: 2.7.2. Designing the Window Interface, Advanced Oracle PL/SQL Programming with Packages

instances of classes: 18.1.4.2. Classification , Oracle PL/SQL Programming

instantiation: (see also master sites, instantiation; snapshots, instantiation)

of objects: 18.2.2.1. PL/SQL usage , Oracle PL/SQL Programming
of program data, storage of: 23.1.4. Key Concepts for Program Execution, Oracle PL/SQL Programming

instsrv utility (Windows NT): 21.2.1. Step 1: Set Up the Listener, Oracle PL/SQL Programming

int_arr data structure, OWA_TEXT package: 7.2.1.1. Data structures, Oracle Web Applications

intab procedure

21.1.6. Displaying the Log, Advanced Oracle PL/SQL Programming with Packages
2.5.4.1. The "in table" procedural interface, Oracle Built-in Packages

intab.sp : 2.5.4.8. Full text of intab procedure, Oracle Built-in Packages

integers: 4.2.1.1. Binary integer datatypes, Oracle PL/SQL Programming

INT subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming
INTEGER subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming
PLS_INTEGER datatype: 4.2.1.3. The PLS_INTEGER datatype, Oracle PL/SQL Programming
SMALLINT subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming
operations on, performance of: 25.4.5. Use PLS_INTEGER for All Integer Operations, Oracle PL/SQL Programming

integrity

1.3.5. Guaranteeing Transaction Integrity, Advanced Oracle PL/SQL Programming with Packages
21.1.5. Rolling Back with PLVlog, Advanced Oracle PL/SQL Programming with Packages

interMedia: 1.1. What's in Oracle8i Release 8.1?, Guide to Oracle8i Features

interdependencies, package: 25.2.4. Creating Packages with Minimal Interdependencies, Oracle PL/SQL Programming

interface

PLVcmt package: 5.7. PLVcmt: Commit Processing, Advanced Oracle PL/SQL Programming with Packages

messages: (see messages)

packages

2.5. Constructing the Optimal Interface to Your Package, Advanced Oracle PL/SQL Programming with Packages
2.10.3. Simplifying Package Interfaces, Advanced Oracle PL/SQL Programming with Packages

to PL/SQL objects

5.20. PLVobj: Object Interface, Advanced Oracle PL/SQL Programming with Packages
11. PLVobj: A Packaged Interface to ALL_OBJECTS, Advanced Oracle PL/SQL Programming with Packages

to PLV_token table: 5.26. PLVtkn: Token Table Interface, Advanced Oracle PL/SQL Programming with Packages

to SQLERRM function: 6.4.2. Obtaining the Error Message, Advanced Oracle PL/SQL Programming with Packages

to foreign key information: 5.12. PLVfk: Foreign Key Interface, Advanced Oracle PL/SQL Programming with Packages

top-down design: 1.3.3. Top-Down Design, Advanced Oracle PL/SQL Programming with Packages

user: 3.4. Improving the User Interface, Advanced Oracle PL/SQL Programming with Packages

window (trace): 2.7.2. Designing the Window Interface, Advanced Oracle PL/SQL Programming with Packages

interfact

DBMS_SQL package: 19.4. PLVdyn: A Code Layer over DBMS_SQL, Advanced Oracle PL/SQL Programming with Packages

internal LOBs

8.2.1.1. Internal and external LOBs, Oracle Built-in Packages
8.2.1.6. The LOB locator, Oracle Built-in Packages
8.2.3. Internal LOB Considerations, Oracle Built-in Packages
1.4.7.6. Large object support, Oracle PL/SQL Programming
BFILE datatype versus: 4.2.7.7. Working with BFILEs, Oracle PL/SQL Programming

internal applications: 1.1. The Internet Grows Up, Oracle Web Applications

internal documentation: (see comments)

internationalization: (see also National Language Support)

NLS character datatypes: 4.2.6. NLS Character Datatypes, Oracle PL/SQL Programming

internet technology, overview: 1. Introduction, Oracle Web Applications

intersession communication: 3. Intersession Communication, Oracle Built-in Packages

problems using databases for: 3.1. DBMS_PIPE: Communicating Between Sessions , Oracle Built-in Packages

interval parameter (job scheduling): 13.1.2.4. The interval parameter, Oracle Built-in Packages

intval function: 10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function , Oracle Built-in Packages

invalid action codes: 3.7. Handling Program Assumptions, Advanced Oracle PL/SQL Programming with Packages

invalids.sql : 15.3.4.3. The DBMS_REPCAT.GENERATE_REPLICATION_TRIGGER procedure, Oracle Built-in Packages

invisible characters: (see whitespace)

invoker rights

1.1. What's in Oracle8i Release 8.1?, Guide to Oracle8i Features
1.3.2. Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? ), Guide to Oracle8i Features
combining with definer rights model: 3.4. Combining the Definer and Invoker Rights Models, Guide to Oracle8i Features
definer rights model: 3.1. A Look at the Definer Rights Model, Guide to Oracle8i Features
dynamic SQL and definer rights: 3.1.4. Dynamic SQL and Definer Rights, Guide to Oracle8i Features
overview: 3.2. The Invoker Rights Model, Guide to Oracle8i Features
rules and restrictions: 3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
schemas: 3.3. One Program, Multiple Schemas, Guide to Oracle8i Features
sharing NDS programs with: 4.6.1. Sharing NDS Programs with Invoker Rights, Guide to Oracle8i Features
syntax: 3.2.1. Invoker Rights Syntax, Guide to Oracle8i Features

is-a relationship: (see inheritance)

is_blank function: 5.6.2. Character type functions, Advanced Oracle PL/SQL Programming with Packages

is_builtin function

5.26.3. Determining type of token , Advanced Oracle PL/SQL Programming with Packages
10.2.2. Determining Token Type, Advanced Oracle PL/SQL Programming with Packages

is_datatype function

5.26.3. Determining type of token , Advanced Oracle PL/SQL Programming with Packages
10.2.2. Determining Token Type, Advanced Oracle PL/SQL Programming with Packages

is_delimiter function: 5.16.1. Analyzing PL/SQL string content, Advanced Oracle PL/SQL Programming with Packages

is_digit function: 5.6.2. Character type functions, Advanced Oracle PL/SQL Programming with Packages

is_exception function

5.26.3. Determining type of token , Advanced Oracle PL/SQL Programming with Packages
10.2.2. Determining Token Type, Advanced Oracle PL/SQL Programming with Packages

is_keyword function

5.26.3. Determining type of token , Advanced Oracle PL/SQL Programming with Packages
10.2.2. Determining Token Type, Advanced Oracle PL/SQL Programming with Packages

is_letter function: 5.6.2. Character type functions, Advanced Oracle PL/SQL Programming with Packages

is_made function: 5.18.2. Creating and destroying lists, Advanced Oracle PL/SQL Programming with Packages

is_nonprinting function: 5.6.2. Character type functions, Advanced Oracle PL/SQL Programming with Packages

is_oneline_comment function: 5.16.1. Analyzing PL/SQL string content, Advanced Oracle PL/SQL Programming with Packages

is_other function: 5.6.2. Character type functions, Advanced Oracle PL/SQL Programming with Packages

is_quote function: 5.6.2. Character type functions, Advanced Oracle PL/SQL Programming with Packages

is_symbol function

5.26.3. Determining type of token , Advanced Oracle PL/SQL Programming with Packages
10.2.2. Determining Token Type, Advanced Oracle PL/SQL Programming with Packages

is_syntax function

5.26.3. Determining type of token , Advanced Oracle PL/SQL Programming with Packages
10.2.2. Determining Token Type, Advanced Oracle PL/SQL Programming with Packages

isolation levels

2.4.2. Transaction Visibility, Guide to Oracle8i Features
6.1.4. The SET TRANSACTION Statement, Oracle PL/SQL Programming

itemin function: 5.24.4. Analyzing stack contents, Advanced Oracle PL/SQL Programming with Packages

iterative

assignment into rows: 10.6.2. Iterative Assignment , Oracle PL/SQL Programming
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 | X | Y | Z