CD Home

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
I/O
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
(see also object names)
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

Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.