start page | rating of books | rating of authors | reviews | copyrights

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: B

BEFORE ROW triggers, replication and: 15.3.4. Replication Support with DBMS_REPCAT, Oracle Built-in Packages
BEFORE SHUTDOWN triggers: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features
BEFORE context, triggers: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features
BEGIN command, PL/SQL: 6.1.1. Procedures, Oracle Web Applications
BEGIN keyword: 4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features
BEGIN-END block syntax
1.4.1. The Package Specification, Advanced Oracle PL/SQL Programming with Packages
1.6.2.1. Package body syntax, Advanced Oracle PL/SQL Programming with Packages
2.2. Using Effective Coding Style for Packages, Advanced Oracle PL/SQL Programming with Packages
BEGIN_DISCRETE_TRANSACTION procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.5.3. The DBMS_TRANSACTION.BEGIN_DISCRETE_TRANSACTION procedure, Oracle Built-in Packages
C.15.14. The BEGIN_DISCRETE_TRANSACTION procedure, Oracle PL/SQL Programming
BEGIN_INSTANTIATION procedure: 15.4.2.1. The DBMS_OFFLINE_OG.BEGIN_INSTANTIATION procedure, Oracle Built-in Packages
BEGIN_LOAD procedure (DBMS_OFFLINE_OG)
15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages
15.4.2.2. The DBMS_OFFLINE_OG.BEGIN_LOAD procedure, Oracle Built-in Packages
BEGIN_LOAD procedure (DBMS_OFFLINE_SNAPSHOT)
14.3.1.1. DBMS_OFFLINE_SNAPSHOT programs, Oracle Built-in Packages
14.3.2.1. The DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD procedure, Oracle Built-in Packages
BEGIN_TABLE_REORGANIZATION procedure
14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
14.1.5.1. The DBMS_SNAPSHOT.BEGIN_TABLE_REORGANIZATION procedure (Oracle8 only), Oracle Built-in Packages
BFILE datatype
1.4.7.6. Large object support, Oracle PL/SQL Programming
4.2.7.7. Working with BFILEs, Oracle PL/SQL Programming
example of using: 20.8. Postscript: Using the BFILE Datatype, Oracle PL/SQL Programming
BFILENAME function
4.2.7.7. Working with BFILEs, Oracle PL/SQL Programming
13.2.1. The BFILENAME function, Oracle PL/SQL Programming
BFILEs
8.2.1. LOB Datatypes, Oracle Built-in Packages
8.2.1.2. The BFILE datatype, Oracle Built-in Packages
closing: 8.3.1.5. The DBMS_LOB.FILECLOSE procedure, Oracle Built-in Packages
exception handling: 8.3.1.6. The DBMS_LOB.FILECLOSEALL procedure, Oracle Built-in Packages
directory aliases: 8.2.2.1. The DIRECTORY object, Oracle Built-in Packages
directory nonexistent exception: 8.3.1.1. The DBMS_LOB.FILEEXISTS function, Oracle Built-in Packages
existence test: 8.3.1.1. The DBMS_LOB.FILEEXISTS function, Oracle Built-in Packages
filenames, returning: 8.3.1.2. The DBMS_LOB.FILEGETNAME procedure, Oracle Built-in Packages
loading: 8.3.1.7. The DBMS_LOB.LOADFROMFILE procedure, Oracle Built-in Packages
locking and: 8.3.1.7. The DBMS_LOB.LOADFROMFILE procedure, Oracle Built-in Packages
opening: 8.3.1.3. The DBMS_LOB.FILEOPEN procedure, Oracle Built-in Packages
exception handling: 8.3.1.3. The DBMS_LOB.FILEOPEN procedure, Oracle Built-in Packages
testing if open: 8.3.1.4. The DBMS_LOB.FILEISOPEN function, Oracle Built-in Packages
populating: 8.2.2.2. Populating a BFILE locator, Oracle Built-in Packages
BINARY_INTEGER datatype
4.2.1.1. Binary integer datatypes, Oracle PL/SQL Programming
25.4.5. Use PLS_INTEGER for All Integer Operations, Oracle PL/SQL Programming
for table declaration: 10.4.1. Defining the Table TYPE, Oracle PL/SQL Programming
BIND_ARRAY procedure
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
index-by tables used by: 2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages
BIND_ARRAY program: 25.3.4. Take Advantage of DBMS_SQL Batch Processing, Oracle PL/SQL Programming
BIND_VARIABLE procedure
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
C.14.2. The BIND_VARIABLE procedure , Oracle PL/SQL Programming
Method 4 dynamic SQL and: 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL, Oracle Built-in Packages
BIND_VARIABLES procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
BIND_VARIABLE_CHAR procedure: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
BIND_VARIABLE_RAW procedure: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
BIND_VARIABLE_ROWID procedure: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
BIT_AND function: 9.2.3.1. The UTL_RAW.BIT_AND function, Oracle Built-in Packages
BIT_COMPLEMENT function: 9.2.3.2. The UTL_RAW.BIT_COMPLEMENT function, Oracle Built-in Packages
BIT_OR function: 9.2.3.3. The UTL_RAW.BIT_OR function, Oracle Built-in Packages
BIT_XOR function: 9.2.3.4. The UTL_RAW.BIT_XOR function, Oracle Built-in Packages
BLOB (binary large object)
7.5.2. DBMS_LOB: Working with Temporary LOBs, Guide to Oracle8i Features
8.2.1. LOB Datatypes, Oracle Built-in Packages
BLOB datatype
1.4.7.6. Large object support, Oracle PL/SQL Programming
4.2.7.2. The BLOB datatype, Oracle PL/SQL Programming
EMPTY_BLOB function: 13.2.2. The EMPTY_BLOB function, Oracle PL/SQL Programming
BLOB_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages
BROKEN procedure
13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
13.2.7.2. The DBMS_JOB.BROKEN procedure, Oracle Built-in Packages
C.5.1. The BROKEN procedure, Oracle PL/SQL Programming
BULK COLLECT clause
1.3.4. Bulk Binds and Collects (Chapter 5, Bulking Up with PL/SQL 8.1), Guide to Oracle8i Features
5. Bulking Up with PL/SQL 8.1, Guide to Oracle8i Features
5.3. Bulk Querying with the BULK COLLECT Clause, Guide to Oracle8i Features
5.5. Analyzing the Impact of Bulk Operations, Guide to Oracle8i Features
BYO packages: 1.5.3. Build-Your-Own Packages, Advanced Oracle PL/SQL Programming with Packages
Best Practices: 16.1. Options for Best Practices, Advanced Oracle PL/SQL Programming with Packages
Booch diagram: 16.2.4. Public and Private Package Elements, Oracle PL/SQL Programming
Boolean
as parameters: 22.7.2. Use Self-Identifying Parameters (Avoid Boolean Values), Oracle PL/SQL Programming
converting to strings: 6.4.1. Converting Boolean to String, Advanced Oracle PL/SQL Programming with Packages
datatype: 4.2.4. The Boolean Datatype, Oracle PL/SQL Programming
function: 16.2.3.2. Generated function examples, Advanced Oracle PL/SQL Programming with Packages
functions returning: 15.5.4.1. Functions without parameters, Oracle PL/SQL Programming
get-and-set procedure: 16.2.4.1. Generating a Boolean get-and-set, Advanced Oracle PL/SQL Programming with Packages
literals: 2.3.3. Boolean Literals, Oracle PL/SQL Programming
variables in IF statements: (see IF statements)
back references (backrefs), OWA_PATTERN package: 7.2.2.1. Regular expressions, Oracle Web Applications
backups: 24.2.6. Document and Back Up Your Efforts, Oracle PL/SQL Programming
backward compatibility
3.3. Supplying Backward Compatibility, Advanced Oracle PL/SQL Programming with Packages
3.11. Don't Forget Backward Compatibility, Advanced Oracle PL/SQL Programming with Packages
bailing_out function
5.10.7. Bailing out program execution, Advanced Oracle PL/SQL Programming with Packages
22.1.10.2. Starting and stopping the bailout, Advanced Oracle PL/SQL Programming with Packages
bailout errors: 22.1.10. Bailing Out with PLVexc, Advanced Oracle PL/SQL Programming with Packages
bailout procedure
5.10.7. Bailing out program execution, Advanced Oracle PL/SQL Programming with Packages
22.1.10.2. Starting and stopping the bailout, Advanced Oracle PL/SQL Programming with Packages
bailout_error function: 22.1.10.1. Managing the bailout error list, Advanced Oracle PL/SQL Programming with Packages
bailout_on procedure: 22.1.10.1. Managing the bailout error list, Advanced Oracle PL/SQL Programming with Packages
banners between package elements: 2.2. Using Effective Coding Style for Packages, Advanced Oracle PL/SQL Programming with Packages
base_timing function: 5.27.6. Calibration and timing scripts, Advanced Oracle PL/SQL Programming with Packages
batch processing
25.3.4. Take Advantage of DBMS_SQL Batch Processing, Oracle PL/SQL Programming
encrypting code and: 23.7.2. Working with Encrypted Code, Oracle PL/SQL Programming
step registration: 7.3.5. Using the register_app Package, Oracle Built-in Packages
best practices
4.1.1. The Benefits of PL/Vision, Advanced Oracle PL/SQL Programming with Packages
16.4.1. PLVgen Coding Guidelines, Advanced Oracle PL/SQL Programming with Packages
binary character objects
8.2.1. LOB Datatypes, Oracle Built-in Packages
8.2.1.5. The NCLOB datatype, Oracle Built-in Packages
binary data: (see RAW datatype)
binary large files: (see BFILEs)
binary large object (BLOB): 7.5.2. DBMS_LOB: Working with Temporary LOBs, Guide to Oracle8i Features
binary large objects: 8.2.1. LOB Datatypes, Oracle Built-in Packages
bind variables
19.5. DML Operations, Advanced Oracle PL/SQL Programming with Packages
19.5.10.2. Avoiding schema confusion for DDL, Advanced Oracle PL/SQL Programming with Packages
bind_argument expression, EXECUTE IMMEDIATE statement: 4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
binding
argument modes: 4.4.3. Argument Modes , Guide to Oracle8i Features
concatenation, compared to: 4.4.1. Binding Versus Concatenation, Guide to Oracle8i Features
host variables: (see host variables, binding)
limitations: 4.4.2. Limitations on Binding, Guide to Oracle8i Features
objects to cursors: 11.5. Binding Objects to a Dynamic Cursor, Advanced Oracle PL/SQL Programming with Packages
bindobj procedure
5.20.8. Miscellaneous PLVobj programs, Advanced Oracle PL/SQL Programming with Packages
11.5. Binding Objects to a Dynamic Cursor, Advanced Oracle PL/SQL Programming with Packages
bit strings, operations on: 9.2.3.1. The UTL_RAW.BIT_AND function, Oracle Built-in Packages
bit-fiddling: 9.2.2.3. Bit-fiddling, Oracle Built-in Packages
bitmasks: 9.2.2.3. Bit-fiddling, Oracle Built-in Packages
blank lines (see whitespace)
blended access: 10.9.5.6. Performance impact of blended access, Oracle PL/SQL Programming
block comments: 2.5.2. Multiline Comment Syntax, Oracle PL/SQL Programming
block numbers: (see data block addresses)
blocks
(see also modules)
2.7. Block Structure, Oracle PL/SQL Programming
15. Procedures and Functions, Oracle PL/SQL Programming
6.1. Structured Programming in PL/SQL , Oracle Web Applications
anonymous: 15.3. The Anonymous PL/SQL Block, Oracle PL/SQL Programming
constructing: 15.2.1. Sequence of Section Construction, Oracle PL/SQL Programming
cursors in: 15.3.5.4. Cursor scope, Oracle PL/SQL Programming
labels for: 15.3.6. Block Labels, Oracle PL/SQL Programming
local: 15.7. Local Modules, Oracle PL/SQL Programming
nested
15.3.4. Nested Blocks , Oracle PL/SQL Programming
15.3.5.2. Scope and nested blocks, Oracle PL/SQL Programming
parameters of: 15.6. Parameters, Oracle PL/SQL Programming
body size limits: 10.5.1. Dramatically Higher Limits on Body Size, Guide to Oracle8i Features
body, HTML tag: 5.2.1. Structural Tags, Oracle Web Applications
body, PL/SQL: 6.1. Structured Programming in PL/SQL , Oracle Web Applications
body, package: (see packages)
book_file function: 8.1.4. About the Examples, Oracle Built-in Packages
book_text function: 8.1.4. About the Examples, Oracle Built-in Packages
book_text_forupdate function: 8.1.4. About the Examples, Oracle Built-in Packages
boolstg function
6.6. The Predefined Constants, Advanced Oracle PL/SQL Programming with Packages
5.3.6. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages
6.4.1. Converting Boolean to String, Advanced Oracle PL/SQL Programming with Packages
bottom-up design, PL/SQL: 6.1. Structured Programming in PL/SQL , Oracle Web Applications
boundary checking: 3.8.1. When the num_in Argument Is 0, Advanced Oracle PL/SQL Programming with Packages
brackets ([ ]): 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
branching with exceptions: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
break_all_jobs procedure
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
13.3.3. DBMS_IJOB: Managing Other Users' Jobs , Oracle Built-in Packages
broadcasting: 5.1.4. Propagation Features, Oracle Built-in Packages
alerts: 3.2. DBMS_ALERT: Broadcasting Alerts to Users, Oracle Built-in Packages
example: 5.7.8. Working with Multiple Consumers, Oracle Built-in Packages
illustration: 5.1.5. A Glossary of Terms, Oracle Built-in Packages
broken links: 1.2.1.2. Keeping sites up to date, Oracle Web Applications
broken parameter (job scheduling): 13.1.2.5. The broken parameter , Oracle Built-in Packages
browser-specific extensions, HTML: 5.2.8. Beware Browser-Specific Extensions, Oracle Web Applications
browsing messages: (see queues, browsing)
building and compiling Java code: 9.2.2. Building and Compiling Your Java Code, Guide to Oracle8i Features
building block packages: 4.2.1. Building Blocks, Advanced Oracle PL/SQL Programming with Packages
building packages: 1.5.3. Build-Your-Own Packages, Advanced Oracle PL/SQL Programming with Packages
built-in
collection methods: 19.6. Collection Built-Ins, Oracle PL/SQL Programming
functionality, taking advantage of: 1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming
built-in packages
(see also packages)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
1.1. The Power of Built-in Packages, Oracle Built-in Packages
Oracle Developer/2000 and: 1.3.6. Calling Built-in Packaged Code from Oracle Developer/2000 Release 1, Oracle Built-in Packages
reference on: C. Built-In Packages, Oracle PL/SQL Programming
SQL statements and: 1.3.7. Accessing Built-in Packaged Technology from Within SQL, Oracle Built-in Packages
capabilities of: 1.1. The Power of Built-in Packages, Oracle Built-in Packages
encapsulation of: 1.3.5. Encapsulating Access to the Built-in Packages, Oracle Built-in Packages
exception handling with: 1.3.4. Exception Handling and Built-in Packages, Oracle Built-in Packages
purity levels for: 1.3.7.1. Calling a packaged function in SQL, Oracle Built-in Packages
referencing elements of: 1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages
source code for: 1.4. Examining Built-in Package Source Code, Oracle Built-in Packages
summary list: 1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
wrapping: 1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages
bulk binds
1.3.4. Bulk Binds and Collects (Chapter 5, Bulking Up with PL/SQL 8.1), Guide to Oracle8i Features
5. Bulking Up with PL/SQL 8.1, Guide to Oracle8i Features
bulk operations, PL/SQL 8.1: 5.5. Analyzing the Impact of Bulk Operations, Guide to Oracle8i Features
bulk querying
BULK COLLECT clause: 5.3. Bulk Querying with the BULK COLLECT Clause, Guide to Oracle8i Features
RETURNING clause: 5.3.3. Using the RETURNING Clause with Bulk Operations, Guide to Oracle8i Features
bulk fetching of multiple columns: 5.3.2. Bulk Fetching of Multiple Columns, Guide to Oracle8i Features
restricting bulk collection: 5.3.1. Restricting Bulk Collection with ROWNUM , Guide to Oracle8i Features
bulktiming.sql: 5.5. Analyzing the Impact of Bulk Operations, Guide to Oracle8i Features
business-to-business systems: 1.1. The Internet Grows Up, Oracle Web Applications
byte strings
range of values: 9.2.3.17. The UTL_RAW.XRANGE function, Oracle Built-in Packages
raw data operations: 9.2.2.2. Slicing and dicing, Oracle Built-in Packages
translation: 9.2.3.15. The UTL_RAW.TRANSLATE function, Oracle Built-in Packages
transliteration: 9.2.3.16. The UTL_RAW.TRANSLITERATE function, Oracle Built-in Packages


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.