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.