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