start page | rating of books | rating of authors | reviews | copyrights
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.