start page | rating of books | rating of authors | reviews | copyrights
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.