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

ABORTED_REQUEST_THRESHOLD procedure
12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages
12.2.3.2. The DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD procedure, Oracle Built-in Packages
ABS function: 13.1.1. The ABS function, Oracle PL/SQL Programming
ACCESS table, tuning: 25.2.3. Tune ACCESS$ Table to Reduce First Execution Time of Code, Oracle PL/SQL Programming
ACID principle: 2.1. Transaction Management in PL/SQL, Guide to Oracle8i Features
ACTIVE_INSTANCES function, DBMS_UTILITY package: 7.7.2. ACTIVE_INSTANCES: Returning a List of Active Instances, Guide to Oracle8i Features
ADD procedure
14.2.1. Getting Started with DBMS_REFRESH, Oracle Built-in Packages
14.2.3.1. The DBMS_REFRESH.ADD procedure, Oracle Built-in Packages
ADD2MULTI procedure, OWA_TEXT package: 7.2.1.2. Procedures, Oracle Web Applications
ADD_<conflicttype>_RESOLUTION procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION, Oracle Built-in Packages
ADD_DEFAULT_DEST procedure
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.2.1. The DBMS_DEFER.SYS.ADD_DEFAULT_DEST procedure, Oracle Built-in Packages
ADD_DELETE_RESOLUTION procedure: 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION, Oracle Built-in Packages
ADD_GROUPED_COLUMN procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.2.3.1. The DBMS_REPCAT.ADD_GROUPED_COLUMN procedure, Oracle Built-in Packages
ADD_MASTER_DATABASE procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.5.1. The DBMS_REPCAT.ADD_MASTER_DATABASE procedure, Oracle Built-in Packages
ADD_MONTHS function: 12.1.1. The ADD_MONTHS function, Oracle PL/SQL Programming
customizing: 12.2.1. Customizing the Behavior of ADD_MONTHS, Oracle PL/SQL Programming
ADD_POLICY procedure, DBMS_RLS package: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features
ADD_PRIORITY_<datatype> procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.3.3.1. The DBMS_REPCAT.ADD_PRIORITY_<datatype> procedure, Oracle Built-in Packages
ADD_SITE_PRIORITY_SITE procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.4.3.1. The DBMS_REPCAT.ADD_SITE_PRIORITY_SITE procedure, Oracle Built-in Packages
ADD_SUBSCRIBER procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.3.1. The DBMS_AQADM.ADD_SUBSCRIBER procedure, Oracle Built-in Packages
7.6.4.1. Rule-based subscribers, Guide to Oracle8i Features
ADD_UNIQUE_RESOLUTION procedure: 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION, Oracle Built-in Packages
ADD_UPDATE_RESOLUTION procedure: 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION, Oracle Built-in Packages
ADMINISTER DATABASE TRIGGER system privilege: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features
ADTs (abstract data types)
6.3. Packages, Oracle Web Applications
22.6. Construct Abstract Data Types (ADTs), Oracle PL/SQL Programming
ADVISE_COMMIT procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.2.1. The DBMS_TRANSACTION.ADVISE_ROLLBACK, and ADVISE_COMMIT procedures, Oracle Built-in Packages
C.15.1. The ADVISE_COMMIT procedure, Oracle PL/SQL Programming
ADVISE_NOTHING procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.2.1. The DBMS_TRANSACTION.ADVISE_ROLLBACK, and ADVISE_COMMIT procedures, Oracle Built-in Packages
C.15.2. The ADVISE_NOTHING procedure, Oracle PL/SQL Programming
ADVISE_ROLLBACK procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.2.1. The DBMS_TRANSACTION.ADVISE_ROLLBACK, and ADVISE_COMMIT procedures, Oracle Built-in Packages
C.15.3. The ADVISE_ROLLBACK procedure, Oracle PL/SQL Programming
AFTER STARTUP triggers: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features
AFTER context, triggers: 6.2. Database-Level Event Triggers, Guide to Oracle8i Features
AIFF format: 1.3.9.2. Multimedia data, Oracle Web Applications
AIFF-C format: 1.3.9.2. Multimedia data, Oracle Web Applications
ALL option, GRANT_QUEUE_PRIVILEGE procedure: 7.6.3.2. REVOKE_QUEUE_PRIVILEGE: Revoking queue-level privileges, Guide to Oracle8i Features
ALLOCATE_UNIQUE procedure
4.1.1.1. DBMS_LOCK programs, Oracle Built-in Packages
4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure, Oracle Built-in Packages
C.7.1. The ALLOCATE_UNIQUE procedure, Oracle PL/SQL Programming
ALL_CONTEXT data dictionary view: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
ALL_ERRORS data dictionary view: 9.6.2. Examining Loaded Java Elements, Guide to Oracle8i Features
ALL_OBJECTS data dictionary view: 9.6.2. Examining Loaded Java Elements, Guide to Oracle8i Features
ALL_OBJECTS view
11.2. ALL_OBJECTS View, Advanced Oracle PL/SQL Programming with Packages
11.4. Accessing ALL_OBJECTS , Advanced Oracle PL/SQL Programming with Packages
identifying objects and, 2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages
ALL_POLICIES data dictionary view: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
ALL_SOURCE data dictionary view
5.15.4. Managing the source repository, Advanced Oracle PL/SQL Programming with Packages
15.4.1. How to Find Source Code, Advanced Oracle PL/SQL Programming with Packages
ALTER JAVA statement: 9.1. Oracle8i and Java, Guide to Oracle8i Features
ALTER SESSION command: 26.1.1. Enabling Program Units for Tracing, Oracle PL/SQL Programming
ALTER TABLE statement: 20.6. Schema Evolution, Oracle PL/SQL Programming
ALTER command
1.3.5. New Trigger Capabilities, Guide to Oracle8i Features
6. New Trigger Features in Oracle8i, Guide to Oracle8i Features
6.3. Schema-Level Event Triggers, Guide to Oracle8i Features
7.2.3. Controlling Trace File Contents, Guide to Oracle8i Features
ALTER_COMPILE procedure
10.3.2. Compiling PL/SQL Objects, Oracle Built-in Packages
C.4.1. The ALTER_COMPILE procedure, Oracle PL/SQL Programming
ALTER_MASTER_PROPAGATION procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.8.2. The DBMS_REPCAT.ALTER_MASTER_PROPAGATION procedure, Oracle Built-in Packages
ALTER_MASTER_REPOBJECT procedure
15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.3.5. The DBMS_REPCAT.ALTER_MASTER_REPOBJECT procedure, Oracle Built-in Packages
ALTER_PRIORITY procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.3.3.2. The DBMS_REPCAT.ALTER_PRIORITY procedure, Oracle Built-in Packages
ALTER_PRIORITY_<datatype> procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.3.3.3. The DBMS_REPCAT.ALTER_PRIORITY_<datatype> procedure, Oracle Built-in Packages
ALTER_QUEUE procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.2.3. The DBMS_AQADM.ALTER_QUEUE procedure, Oracle Built-in Packages
C.3.2.4. The ALTER_QUEUE procedure, Oracle PL/SQL Programming
ALTER_SITE_PRIORITY procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.4.3.3. The DBMS_REPCAT.ALTER_SITE_PRIORITY procedure, Oracle Built-in Packages
ALTER_SITE_PRIORITY_SITE procedure
16.1.1. DBMS_REPCAT Programs, Oracle Built-in Packages
16.4.3.4. The DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE, Oracle Built-in Packages
ALTER_SNAPSHOT_PROPAGATION procedure
14.4.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
14.4.4. Altering a Snapshot Replication Group's Propagation Mode, Oracle Built-in Packages
ALTER_TABLE_NOT_REFERENCEABLE procedure
10.3.1.1. DBMS_DDL programs, Oracle Built-in Packages
10.3.4.2. The DBMS_DDL.ALTER_TABLE_NOT_REFERENCEABLE procedure (Oracle8 only), Oracle Built-in Packages
ALTER_TABLE_REFERENCEABLE procedure
10.3.1.1. DBMS_DDL programs, Oracle Built-in Packages
10.3.4.1. The DBMS_DDL. (Oracle8 only), Oracle Built-in Packages
AMATCH function, OWA_PATTERN package: 7.2.2.3. Procedures and functions, Oracle Web Applications
ANALYZE statement: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming
ANALYZE_DATABASE procedure
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.1. The DBMS_UTILITY.ANALYZE_DATABASE procedure, Oracle Built-in Packages
ANALYZE_OBJECT procedure
10.3.1.1. DBMS_DDL programs, Oracle Built-in Packages
10.3.3.1. The DBMS_DDL.ANALYZE_OBJECT procedure, Oracle Built-in Packages
C.4.2. The ANALYZE_OBJECT procedure, Oracle PL/SQL Programming
ANALYZE_PART_OBJECT procedure
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only), Oracle Built-in Packages
ANALYZE_SCHEMA procedure
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.2. The DBMS_UTILITY.ANALYZE_SCHEMA procedure, Oracle Built-in Packages
C.16.1. The ANALYZE_SCHEMA procedure, Oracle PL/SQL Programming
ANCHOR function, HTF package: 7.1.3. HTF: Parsing HTML, Oracle Web Applications
ANCHOR function, HTP package: 7.1.1. HTP: Generating HTML, Oracle Web Applications
AND bit operation: 9.2.3.1. The UTL_RAW.BIT_AND function, Oracle Built-in Packages
ANO (Advanced Networking Option): 2.5.5. Additional Security Precautions, Oracle Web Applications
ANY parameters: 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4), Oracle Built-in Packages
ANY_CHAR_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages
ANY_CLOB_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages
ANY_VARCHAR2_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages
APIs (application programming interfaces)
7.1. DBMS_PROFILER: Providing Code Profiling , Guide to Oracle8i Features
1.3.8. Calling Java from PL/SQL , Guide to Oracle8i Features
7.2. DBMS_TRACE: Providing a PL/SQL Trace Facility, Guide to Oracle8i Features
1.3.8.4. InternetLite server and API, Oracle Web Applications
6.3. Packages, Oracle Web Applications
APPEND procedure
8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.3.1. The DBMS_LOB.APPEND procedure, Oracle Built-in Packages
C.6.1. The APPEND procedure , Oracle PL/SQL Programming
AQ (Advanced Queuing)
5. Oracle Advanced Queuing, Oracle Built-in Packages
1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
1.3.10. Advanced Queuing, Oracle Web Applications
Oracle8 versions and
5. Oracle Advanced Queuing, Oracle Built-in Packages
5.2.2.3. Setting Oracle AQ compatibility, Oracle Built-in Packages
components of: 5.1.6. Components of Oracle AQ, Oracle Built-in Packages
constants
5.3.1.1. Administrative tasks, Oracle Built-in Packages
5.3.1.2. Operational tasks, Oracle Built-in Packages
creating: 5.2.1. Installing the Oracle AQ Facility, Oracle Built-in Packages
data structures: 5.3. Oracle AQ Nonprogram Elements, Oracle Built-in Packages
data typing and: 5.1.1. General Features, Oracle Built-in Packages
database objects
5.6. Oracle AQ Database Objects, Oracle Built-in Packages
5.6.1. Objects Per Queue Table , Oracle Built-in Packages
data dictionary: 5.6.2. Data Dictionary Objects, Oracle Built-in Packages
dequeuing: (see dequeuing)
encapsulating (example): 5.7.1. Improving AQ Ease of Use, Oracle Built-in Packages
enqueuing: (see enqueuing)
example scripts (by Oracle): 5.7. Oracle AQ Examples, Oracle Built-in Packages
examples: 5.7. Oracle AQ Examples, Oracle Built-in Packages
browsing: 5.7.4. Browsing a Queue's Contents, Oracle Built-in Packages
encapsulating: 5.7.1. Improving AQ Ease of Use, Oracle Built-in Packages
message groups: 5.7.7. Working with Message Groups, Oracle Built-in Packages
multiple consumers: 5.7.8. Working with Multiple Consumers, Oracle Built-in Packages
prioritized queues: 5.7.2. Working with Prioritized Queues, Oracle Built-in Packages
searching by correlation identifier: 5.7.5. Searching by Correlation Identifier, Oracle Built-in Packages
time delay and expiration: 5.7.6. Using Time Delay and Expiration, Oracle Built-in Packages
exceptions
5.1.3. Dequeue Features, Oracle Built-in Packages
5.3.9. Oracle AQ Exceptions, Oracle Built-in Packages
features: 5.1.1. General Features, Oracle Built-in Packages
glossary of terms: 5.1.5. A Glossary of Terms, Oracle Built-in Packages
installing: 5.2.1. Installing the Oracle AQ Facility, Oracle Built-in Packages
object names: 5.3.2. Object Names, Oracle Built-in Packages
pipes versus: 3.1.2.3. Pipe communications logic, Oracle Built-in Packages
privileges
5.2.1. Installing the Oracle AQ Facility, Oracle Built-in Packages
5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
propagation: (see propagating messages)
recipient list: 5.3.6. Message Properties Record Type, Oracle Built-in Packages
roles: 5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
stacks (example): 5.7.3. Building a Stack with AQ Using Sequence Deviation, Oracle Built-in Packages
tables and: 5.1.1. General Features, Oracle Built-in Packages
views for
data dictionary: 5.1.8. Data Dictionary Views, Oracle Built-in Packages
per queue table: 5.6.1.2. The queue table view, Oracle Built-in Packages
AQ Lite: 1.3.8.3. AQ Lite, Oracle Web Applications
AQ_ADMINISTRATOR_ROLE: 5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
AQ_USER_ROLE
5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
7.6.2. System-Level Access Control, Guide to Oracle8i Features
ASCII characters: (see characters, string)
ASCII function: 11.1.1. The ASCII function, Oracle PL/SQL Programming
AUF format: 1.3.9.2. Multimedia data, Oracle Web Applications
AUTHID CURRENT_USER clause
1.3.2. Invoker Rights , Guide to Oracle8i Features
3.2.1. Invoker Rights Syntax, Guide to Oracle8i Features
AUTHID DEFINER clause: 3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
AVI
1.3.9.2. Multimedia data, Oracle Web Applications
2.1. Resources, Oracle Web Applications
Ada programming language
Preface, Oracle PL/SQL Programming
6. PL/SQL, Oracle Web Applications
Adobe PDF: 1.3.9.1. Text data, Oracle Web Applications
Advanced Networking Option (ANO): 2.5.5. Additional Security Precautions, Oracle Web Applications
Advanced Queuing (AQ)
1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
1.3.10. Advanced Queuing, Oracle Web Applications
1.3.5. New Trigger Capabilities, Guide to Oracle8i Features
6. New Trigger Features in Oracle8i, Guide to Oracle8i Features
6.2.1.2. Tracking logins to the database, Guide to Oracle8i Features
7.6. New DBMS_AQ and DBMS_AQADM Features, Guide to Oracle8i Features
Alpha: 1.2.2.2. Developers must know too many platforms, Oracle Web Applications
AltaVista: 1.2.1.1. Finding what you need, Oracle Web Applications
abbreviations: 2.3.3. Avoiding Superfluous Naming Elements, Advanced Oracle PL/SQL Programming with Packages
absolute file numbers, returning: 9.1.3.7. The DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO function, Oracle Built-in Packages
absolute value: 13.1.1. The ABS function, Oracle PL/SQL Programming
abstract data types (ADTs): 6.3. Packages, Oracle Web Applications
abstraction: 18.1.5.3. Abstraction , Oracle PL/SQL Programming
access
ALL_OBJECTS view: 11.4. Accessing ALL_OBJECTS , Advanced Oracle PL/SQL Programming with Packages
PL/SQL tables: (see PLVtab package)
PL/Vision: 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
data structure, encapsulating: 1.7.2. Synchronize Program and Data Structures, Oracle PL/SQL Programming
messages: 5.19.2. Managing and accessing message text, Advanced Oracle PL/SQL Programming with Packages
package elements
1.3.1. Enforced Information Hiding, Advanced Oracle PL/SQL Programming with Packages
1.4.4. Access to Package Elements, Advanced Oracle PL/SQL Programming with Packages
1.6.1.5. Isolate volatile areas of functionality, Advanced Oracle PL/SQL Programming with Packages
2.7. Building Windows Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
2.10. Hiding Package Data, Advanced Oracle PL/SQL Programming with Packages
stacks: 5.28.5. Accessing the PL/SQL call stack, Advanced Oracle PL/SQL Programming with Packages
to SQL, minimizing: 25.3.1. Use Package Data to Minimize SQL Access, Oracle PL/SQL Programming
to compiled code, tuning: 25.2. Tuning Access to Compiled Code, Oracle PL/SQL Programming
to data, tuning: 25.3. Tuning Access to Your Data, Oracle PL/SQL Programming
to operating system files: 13.1.1. Enabling File Access in the Oracle Server , Advanced Oracle PL/SQL Programming with Packages
accessing objects: 5.20.4. Accessing the current object, Advanced Oracle PL/SQL Programming with Packages
accessing PL/SQL call stack: 21.2.2. Accessing the PL/SQL Call Stack, Advanced Oracle PL/SQL Programming with Packages
access control, system level: 7.6.2. System-Level Access Control, Guide to Oracle8i Features
accounts payable: 1.1. The Internet Grows Up, Oracle Web Applications
accounts receivable: 1.1. The Internet Grows Up, Oracle Web Applications
action names
registering: 7.2.5. The DBMS_APPLICATION_INFO.SET_MODULE procedure, Oracle Built-in Packages
returning: 7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure, Oracle Built-in Packages
action procedure
21.2.3. Tracing Code Execution, Advanced Oracle PL/SQL Programming with Packages
7.3.1. About the register_app Package, Oracle Built-in Packages
7.3.2. The action Procedure, Oracle Built-in Packages
actual parameters, PL/SQL
15.6.3. Actual and Formal Parameters, Oracle PL/SQL Programming
6.1.3. Parameters, Oracle Web Applications
ad-hoc query generation, Method 4 dynamic SQL used for: 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL, Oracle Built-in Packages
add_text procedure
5.19.2. Managing and accessing message text, Advanced Oracle PL/SQL Programming with Packages
9.2. Storing Message Text, Advanced Oracle PL/SQL Programming with Packages
9.3.1. Substituting Oracle Messages, Advanced Oracle PL/SQL Programming with Packages
22.1.6.4. Defining error messages with PLVmsg, Advanced Oracle PL/SQL Programming with Packages
adding collection elements: 19.4.3. Adding and Removing Elements, Oracle PL/SQL Programming
addname procedure: 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function, Oracle Built-in Packages
admin_option parameter, GRANT_SYSTEM_PRIVILEGE procedure: 7.6.2.1. GRANT_SYSTEM_PRIVILEGE: Granting system-level privileges, Guide to Oracle8i Features
administration of Oracle databases: About the Contents, Oracle PL/SQL Programming
administration, Oracle/AQ: C.3.2. DBMS_AQADM (PL/SQL 8 Only), Oracle PL/SQL Programming
administrator accounts: (see advanced replication, administrator accounts)
administrator role (AQ): 5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
advanced queuing: 1.4.7.2. Oracle/AQ, the Advanced Queueing Facility, Oracle PL/SQL Programming
advanced replication
15. Advanced Replication, Oracle Built-in Packages
account creation: 15.1. DBMS_REPCAT_AUTH: Setting Up Administrative Accounts, Oracle Built-in Packages
administrator accounts: 15.2. DBMS_REPCAT_ADMIN: Setting Up More Administrator Accounts, Oracle Built-in Packages
granting privileges: 15.2.2.1. The DBMS_REPCAT_ADMIN.GRANT_ADMIN_REPGROUP procedure, Oracle Built-in Packages
revoking privileges
15.2.2.2. The DBMS_REPCAT_ADMIN.REVOKE_ADMIN_REPGROUP procedure, Oracle Built-in Packages
15.2.2.4. The DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_REPGROUP procedure, Oracle Built-in Packages
propagator accounts: 15.1.3. Granting and Revoking Propagator Accounts (Oracle8), Oracle Built-in Packages
remote destinations and: 17.1.1. About Remote Destinations, Oracle Built-in Packages
user accounts: 15.1.2. Granting and Revoking Surrogate SYS Accounts, Oracle Built-in Packages
granting privileges: 15.1.2.1. The DBMS_REPCAT_AUTH.GRANT_SURROGATE_REPCAT procedure, Oracle Built-in Packages
revoking privileges: 15.1.2.2. The DBMS_REPCAT_AUTH.REVOKE_SURROGATE_REPCAT procedure, Oracle Built-in Packages
agents
(see also consumers; producers)
5.1.5. A Glossary of Terms, Oracle Built-in Packages
object type for: 5.3.4. Agents Object Type, Oracle Built-in Packages
aggregate
assignment into rows: 10.6.3. Aggregate Assignment , Oracle PL/SQL Programming
operations
9.1.3.2. Aggregate operations, Oracle PL/SQL Programming
9.5.4. Aggregate Assignment , Oracle PL/SQL Programming
9.6.1.2. Records of the same type, Oracle PL/SQL Programming
of nested records: 9.7.3. Aggregate Assignments of Nested Records, Oracle PL/SQL Programming
values, combining with scalars: 17.8.2. Combining Scalar and Aggregate Values, Oracle PL/SQL Programming
aggregation: 18.1.4.3. Inheritance
alerts
(see also DBMS_ALERT package)
3.2. DBMS_ALERT: Broadcasting Alerts to Users, Oracle Built-in Packages
locking and: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure, Oracle Built-in Packages
names for: 3.2.2.1. The DBMS_ALERT.REGISTER procedure, Oracle Built-in Packages
registering: 3.2.2.1. The DBMS_ALERT.REGISTER procedure, Oracle Built-in Packages
removing: 3.2.2.2. The DBMS_ALERT.REMOVE procedure, Oracle Built-in Packages
setting defaults: 3.2.2.4. The DBMS_ALERT.SET_DEFAULTS procedure, Oracle Built-in Packages
signaling: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure, Oracle Built-in Packages
transactional behavior: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure, Oracle Built-in Packages
waiting for: 3.2.2.6. The DBMS_ALERT.WAITANY procedure, Oracle Built-in Packages
algorithms, tuning: 25.4. Tuning Your Algorithms, Oracle PL/SQL Programming
aliases
column
6.7. Column Aliases in Cursors, Oracle PL/SQL Programming
9.3.2. Setting the Record's Column Names, Oracle PL/SQL Programming
for cursor variables: 6.12.6.3. Cursor variable aliases, Oracle PL/SQL Programming
directory, BFILENAME function and: 13.2.1. The BFILENAME function, Oracle PL/SQL Programming
table names: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features
alignment of code: (see coding, layout of)
allocating cursors: (see cursors, opening; cursors, reusing)
alternate indexes, hashing and (example): 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function, Oracle Built-in Packages
anchored datatypes
1.6.1. Anchored declarations, Oracle PL/SQL Programming
4.5. Anchored Declarations, Oracle PL/SQL Programming
anchoring to subtypes: 4.6.3. Emulating Constrained Subtypes, Oracle PL/SQL Programming
anchored declarations
6.2.2.1. Declaring a variable, Oracle Web Applications
2.10.5. Anchoring to Public Variables, Advanced Oracle PL/SQL Programming with Packages
angle brackets (>) as label delimiters: 5.2.1. The GOTO Statement, Oracle PL/SQL Programming
anonymous blocks
1.3.1. Autonomous Transactions, Guide to Oracle8i Features
10.5. Miscellaneous and Minor Improvements, Guide to Oracle8i Features
15.3. The Anonymous PL/SQL Block, Oracle PL/SQL Programming
in Oracle Tools: 15.3.3. Anonymous Blocks in the Oracle Tools, Oracle PL/SQL Programming
labels for: 15.3.6. Block Labels, Oracle PL/SQL Programming
nested: 15.3.4. Nested Blocks , Oracle PL/SQL Programming
answer_survey procedure
8.2.4.2. Body, Oracle Web Applications
8.2.4. The EMP_SURVEY Package, Oracle Web Applications
8.2.4.2. Body, Oracle Web Applications
apinex1.sql
7.2.3.2. Example, Oracle Built-in Packages
7.2.4.2. Example, Oracle Built-in Packages
7.2.5.2. Example, Oracle Built-in Packages
apinex2.sql : 7.2.6.1. Example, Oracle Built-in Packages
apinex3.sql : 7.3.9. Tracking Long-Running Processes, Oracle Built-in Packages
append_line procedure
5.11.10. Writing to a file, Advanced Oracle PL/SQL Programming with Packages
13.6.1. Appending a Line, Advanced Oracle PL/SQL Programming with Packages
appenditem procedure: 5.18.3. Modifying list contents , Advanced Oracle PL/SQL Programming with Packages
application development
1. Introduction, Oracle Web Applications
1.2. Current Web Techniques Are Inadequate, Oracle Web Applications
WebDB: 3.1.2. Application Development, Oracle Web Applications
application integration: 1.2. Current Web Techniques Are Inadequate, Oracle Web Applications
application programming interfaces (APIs)
1.3.8.4. InternetLite server and API, Oracle Web Applications
6.3. Packages, Oracle Web Applications
applications, tuning: 25. Tuning PL/SQL Applications, Oracle PL/SQL Programming
access to compiled code: 25.2. Tuning Access to Compiled Code, Oracle PL/SQL Programming
access to data: 25.3. Tuning Access to Your Data, Oracle PL/SQL Programming
analyzing performance: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming
optimizing algorithms: 25.4. Tuning Your Algorithms, Oracle PL/SQL Programming
aq package
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
5.3.2. Object Names, Oracle Built-in Packages
5.4.1.2. Examples, Oracle Built-in Packages
5.7.1. Improving AQ Ease of Use, Oracle Built-in Packages
aq.spp
5.3.2. Object Names, Oracle Built-in Packages
5.7.1. Improving AQ Ease of Use, Oracle Built-in Packages
aq.sql file: 6.2.1.2. Tracking logins to the database, Guide to Oracle8i Features
aqadmset.sql file: 5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
aqbrowse package
5.7.4. Browsing a Queue's Contents, Oracle Built-in Packages
aqbrowse.sp
5.7.1. Improving AQ Ease of Use, Oracle Built-in Packages
5.7.4. Browsing a Queue's Contents, Oracle Built-in Packages
aqbrowse.tst : 5.7.4. Browsing a Queue's Contents, Oracle Built-in Packages
aqcorrid.spp
5.7.4.1. A template for a show_queue procedure , Oracle Built-in Packages
5.7.5. Searching by Correlation Identifier, Oracle Built-in Packages
aqcorrid.tst : 5.7.5. Searching by Correlation Identifier, Oracle Built-in Packages
aqcref.sql : 5.5.2.2. The DBMS_AQADM.START_QUEUE procedure, Oracle Built-in Packages
aqcremq.sql : 5.5.3.3. The DBMS_AQADM.QUEUE_SUBSCRIBERS procedure, Oracle Built-in Packages
aqcrepq.sql : 5.5.2.2. The DBMS_AQADM.START_QUEUE procedure, Oracle Built-in Packages
aqcreq.sql : 5.5.2.2. The DBMS_AQADM.START_QUEUE procedure, Oracle Built-in Packages
aqdemo*.sql scripts: 5.7. Oracle AQ Examples, Oracle Built-in Packages
aqdeq1.sql : 5.4.2.2. Examples, Oracle Built-in Packages
aqdeq2.sql : 5.4.2.2. Examples, Oracle Built-in Packages
aqdeq3.sql : 5.4.2.4. Dequeue order , Oracle Built-in Packages
aqdeq4.sql : 5.4.2.4. Dequeue order , Oracle Built-in Packages
aqenq1.sql : 5.4.1.2. Examples, Oracle Built-in Packages
aqenq2.sql : 5.4.1.2. Examples, Oracle Built-in Packages
aqfor.sql file: 5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
aqgroup.spp : 5.7.7.2. Dequeuing messages when part of a group, Oracle Built-in Packages
aqlisten.sql file: 7.6.4.2. LISTEN: Listening for messages, Guide to Oracle8i Features
aqmult.ins : 5.7.8.1. Using the subscriber list, Oracle Built-in Packages
aqmult1.spp : 5.7.8.1. Using the subscriber list, Oracle Built-in Packages
aqmult2.ins : 5.7.8.1. Using the subscriber list, Oracle Built-in Packages
aqmult2.spp : 5.7.8.1. Using the subscriber list, Oracle Built-in Packages
aqmult2.tst : 5.7.8.1. Using the subscriber list, Oracle Built-in Packages
aqmult3.spp : 5.7.8.2. Overriding with a recipient list, Oracle Built-in Packages
aqmult3.tst : 5.7.8.2. Overriding with a recipient list, Oracle Built-in Packages
aqshomsg.sql : 5.4.1.2. Examples, Oracle Built-in Packages
aqshowq package: 5.7.4.1. A template for a show_queue procedure , Oracle Built-in Packages
aqshowq.sp : 5.7.4.1. A template for a show_queue procedure , Oracle Built-in Packages
aqstk package: 5.7.3. Building a Stack with AQ Using Sequence Deviation, Oracle Built-in Packages
aqstk.spp : 5.7.3. Building a Stack with AQ Using Sequence Deviation, Oracle Built-in Packages
aqstk2.spp : 5.7.3. Building a Stack with AQ Using Sequence Deviation, Oracle Built-in Packages
aqtiming.ins : 5.7.6. Using Time Delay and Expiration, Oracle Built-in Packages
aqtiming.spp : 5.7.6. Using Time Delay and Expiration, Oracle Built-in Packages
aqtiming.tst : 5.7.6. Using Time Delay and Expiration, Oracle Built-in Packages
arg function: 10.2.3.1. Features of the psdesc package, Oracle Built-in Packages
args procedure: 10.2.3.1. Features of the psdesc package, Oracle Built-in Packages
arguments
(see also parameters)
10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure, Oracle Built-in Packages
RPC arguments: (see RPCs, arguments)
trapping invalid: 22.2.4.1. Trap invalid argument values, Oracle PL/SQL Programming
arrayemp.sp : 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure, Oracle Built-in Packages
arrays
(see also tables)
1.4.3.4. PL/SQL tables , Oracle PL/SQL Programming
DBMS_SQL used for processing: 2.5.6. Array Processing with DBMS_SQL, Oracle Built-in Packages
Oracle8 and: 2.5.6.1. Using array processing to insert, Oracle Built-in Packages
binding variables
2.3.4. Binding Values into Dynamic SQL, Oracle Built-in Packages
2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
building with tables: 10.9.4. Building Traditional Arrays with PL/SQL Tables, Oracle PL/SQL Programming
copying index tables: 2.5.6.5. Using array processing in dynamic PL/SQL , Oracle Built-in Packages
defining columns: 2.3.5.2. The DBMS_SQL.DEFINE_ARRAY procedure, Oracle Built-in Packages
deleting rows
2.5.6.2. Using array processing to delete, Oracle Built-in Packages
2.5.7.2. RETURNING from a multiple-row delete, Oracle Built-in Packages
fetching rows: 2.5.6.4. Using array processing to fetch, Oracle Built-in Packages
index-by tables and
2.2.6. DBMS_SQL Nonprogram Elements, Oracle Built-in Packages
2.5.6. Array Processing with DBMS_SQL, Oracle Built-in Packages
inserting rows: 2.5.6.1. Using array processing to insert, Oracle Built-in Packages
package for: 10.9.4.3. Features of the array package, Oracle PL/SQL Programming
performance of fetching: 2.5.6.4. Using array processing to fetch, Oracle Built-in Packages
PL/SQL: 6.2.6. Index-by Tables (Arrays), Oracle Web Applications
updating rows: 2.5.6.3. Using array processing to update, Oracle Built-in Packages
variable arrays
2.4.1. Some Restrictions, Oracle Built-in Packages
1.4.7.3. Variable arrays and nested tables, Oracle PL/SQL Programming
objects for: 18.1.2. Some Simple Examples, Oracle PL/SQL Programming
variable-size: (see VARRAYs)
arrayupd.spp : 2.5.6.3. Using array processing to update, Oracle Built-in Packages
arrayupd.tst : 2.5.6.3. Using array processing to update, Oracle Built-in Packages
as.spp : 5.3.2. Object Names, Oracle Built-in Packages
asrc procedure
5.15.4. Managing the source repository, Advanced Oracle PL/SQL Programming with Packages
12.3.4. High-Level Source Management Programs, Advanced Oracle PL/SQL Programming with Packages
assert procedure
5.3.5. Assertion routines, Advanced Oracle PL/SQL Programming with Packages
6.3. Assertion Routines, Advanced Oracle PL/SQL Programming with Packages
assert_inrange function: 6.3.3. Asserting "In Range", Advanced Oracle PL/SQL Programming with Packages
assert_inrange procedure: 5.3.5. Assertion routines, Advanced Oracle PL/SQL Programming with Packages
assert_notnull function
6.3.2. Asserting NOT NULL, Advanced Oracle PL/SQL Programming with Packages
5.3.5. Assertion routines, Advanced Oracle PL/SQL Programming with Packages
assertion modules: 22.2.4. Use Assertion Modules to Validate Parameters and Assumptions, Oracle PL/SQL Programming
assertion routines
3.7. Handling Program Assumptions, Advanced Oracle PL/SQL Programming with Packages
5.3.5. Assertion routines, Advanced Oracle PL/SQL Programming with Packages
6.3. Assertion Routines, Advanced Oracle PL/SQL Programming with Packages
assertion, OWA_PATTERN package
7.2.2.1. Regular expressions, Oracle Web Applications
7.2.2.1. Regular expressions, Oracle Web Applications
assertion_failure exception
5.3.5. Assertion routines, Advanced Oracle PL/SQL Programming with Packages
6.3. Assertion Routines, Advanced Oracle PL/SQL Programming with Packages
assign procedure
2.5.5. Indirect Referencing in PL/SQL, Oracle Built-in Packages
2.5.5.1. Assigning a value, Oracle Built-in Packages
assigning objects: 18.4.1.2. Direct assignment, Oracle PL/SQL Programming
assignment (\:=) operator
2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
4.4.3. Default Values, Oracle PL/SQL Programming
9.5. Assigning Values to and from Records, Oracle PL/SQL Programming
association operator for positional notation (=>): 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
association, object: 18.1.4.3. Inheritance , Oracle PL/SQL Programming
asynchronous mode, replication: 1.3.8.2. EnterpriseSync Lite, Oracle Web Applications
atomics: (see parsing)
atomics of PL/SQL language: 2.1. The PL/SQL Character Set, Oracle PL/SQL Programming
attributes, cursor
6.9. Cursor Attributes, Oracle PL/SQL Programming
6.12.2. Similarities to Static Cursors, Oracle PL/SQL Programming
attributes, object: 18.1.1. Terminology, Oracle PL/SQL Programming
collections as: 19.2.1.2. Collection as an attribute of an object type, Oracle PL/SQL Programming
dot notation for
18.3.4.1. Dots in data structures, Oracle PL/SQL Programming
18.3.4.3. Attribute or method?, Oracle PL/SQL Programming
object equality and: 18.3.6.2. Equality comparisons, Oracle PL/SQL Programming
auction package
(see also specific program names)
3.2.3.3. Auction system requirements, Oracle Built-in Packages
auction.ddl : 3.2.3.2. The auction schema, Oracle Built-in Packages
auction1.sql : 3.2.3.5. The auction package, Oracle Built-in Packages
author function
5.13.3. Setting the author, Advanced Oracle PL/SQL Programming with Packages
16.3.2. Setting the Code Author, Advanced Oracle PL/SQL Programming with Packages
author string: 5.13.3. Setting the author, Advanced Oracle PL/SQL Programming with Packages
author, code: 16.3.2. Setting the Code Author, Advanced Oracle PL/SQL Programming with Packages
authority: (see privileges)
execute/run: (see execute authority)
automatic recovery: 4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure, Oracle Built-in Packages
autonomous blocks, definition: 2.4. Rules and Restrictions, Guide to Oracle8i Features
autonomous transactions
6.2. Database-Level Event Triggers, Guide to Oracle8i Features
1.1. What's in Oracle8i Release 8.1?, Guide to Oracle8i Features
1.3.1. Autonomous Transactions, Guide to Oracle8i Features
autonomous logging mechanism example: 2.5.1. Building an Autonomous Logging Mechanism, Guide to Oracle8i Features
database triggers example: 2.5.2. Using Autonomous Transactions in a Database Trigger, Guide to Oracle8i Features
definition: 2.2. Defining Autonomous Transactions, Guide to Oracle8i Features
retry counter example: 2.5.3. Building a Retry Counter , Guide to Oracle8i Features
rules and restrictions: 2.4. Rules and Restrictions, Guide to Oracle8i Features
transaction management: 2.1. Transaction Management in PL/SQL, Guide to Oracle8i Features
transaction visibility: 2.4.2. Transaction Visibility, Guide to Oracle8i Features
using within SQL: 2.4.1. Using Autonomous Transactions from Within SQL, Guide to Oracle8i Features
when to use: 2.3. When to Use Autonomous Transactions, Guide to Oracle8i Features


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.