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.