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.