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

Index: U

underscore (_) : 5.7.5.1. Wildcarded correlation identifiers

unique_id function

11.1.5.1. Adding value to DBMS_SESSION

11.1.5.2. The unique_id function

UNIQUE_SESSION_ID function

11.1.1.1. DBMS_SESSION programs

11.1.3.2. The DBMS_SESSION.UNIQUE_SESSION_ID function

UNIQUE_SESSION_NAME function

3.1.1.1. DBMS_PIPE programs

3.1.3.5. The DBMS_PIPE.UNIQUE_SESSION_NAME function

UNIQUE_SESSION_ID versus : 11.1.3.2. The DBMS_SESSION.UNIQUE_SESSION_ID function

uniqueness conflicts

(see also insert conflicts)

16.5.1. About Resolution Methods

resolution methods : 16.5.1. About Resolution Methods

UNKEEP procedure

12.2.1. Getting Started with DBMS_SHARED_POOL

12.2.2.2. The DBMS_SHARED_POOL.UNKEEP procedure

unpack_all_items procedure : 3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function

UNPACK_MESSAGE procedure

3.1.1.1. DBMS_PIPE programs

3.1.4.4. The DBMS_PIPE.UNPACK_MESSAGE procedure

UNPACK_MESSAGE_RAW procedure

3.1.1.1. DBMS_PIPE programs

3.1.4.5. The DBMS_PIPE.UNPACK_MESSAGE_RAW procedure

UNPACK_MESSAGE_ROWID procedure

3.1.1.1. DBMS_PIPE programs

3.1.4.6. The DBMS_PIPE.UNPACK_MESSAGE_ROWID procedure

unpack_to_tbl procedure : 3.1.7.3. The dbpipe utility package

UNREGISTER_PROPAGATOR procedure

17.2.1.1. DBMS_DEFER_SYS programs

17.2.6.9. The DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR procedure (Oracle8 only)

UNREGISTER_SNAPSHOT procedure

14.1.1. Getting Started with DBMS_SNAPSHOT

14.1.6.2. The DBMS_SNAPSHOT.UNREGISTER_SNAPSHOT procedures (Oracle8 only)

UNSCHEDULE_EXECUTION procedure

17.2.1.1. DBMS_DEFER_SYS programs

17.2.5.4. The DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION procedure

UNSCHEDULE_PROPAGATION procedure

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)

5.5.5.2. The DBMS_AQADM.UNSCHEDULE_PROPAGATION procedure

UNSCHEDULE_PURGE procedure

17.2.1.1. DBMS_DEFER_SYS programs

17.2.6.6. The DBMS_DEFER_SYS.UNSCHEDULE_PURGE procedure (Oracle8 only)

UNSCHEDULE_PUSH procedure

17.2.1.1. DBMS_DEFER_SYS programs

17.2.6.7. The DBMS_DEFER_SYS.UNSCHEDULE_PUSH procedure (Oracle8 only)

unused_blocks function : 12.1.3.1. The segspace package

UNUSED_SPACE procedure

12.1.1. Getting Started with DBMS_SPACE

12.1.2.2. The DBMS_SPACE.UNUSED_SPACE procedure

upd function : 10.2.3.2. Using psdesc.args as a quality assurance tool

updarray.sp : 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure

update conflicts : 16. Conflict Resolution

dropping priority groups and conflict resolution : 16.3.2.2. The DBMS_REPCAT.DROP_PRIORITY_GROUP procedure

resolution methods : 16.5.1. About Resolution Methods

UPDATE statements, array processing and : 2.5.6.3. Using array processing to update

UPDATE_OBJECT procedure : 9.2.5.4. The UTL_REF.UPDATE_OBJECT procedure

update_row procedure : 7.3.9. Tracking Long-Running Processes

upddelist.sp : 10.1.2.4. The DBMS_UTILITY.COMMA_TO_TABLE procedure

usage : (see performance analysis)

USE_ROLLBACK_SEGMENT procedure

4.2.1.1. DBMS_TRANSACTION programs

4.2.4.5. The DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT procedure

user accounts : (see advanced replication, user accounts)

user queues : 5.1.5. A Glossary of Terms

user role (AQ) : 5.2.3. Authorizing Accounts to Use Oracle AQ

USER_EXPORT procedure

13.1.1. DBMS_JOB Programs

13.2.8.1. The DBMS_JOB.USER_EXPORT procedure

USER_JOBS view : 13.3.2. Viewing Job Information in the Data Dictionary

USER_OBJECTS view : 2.5.1. A Generic Drop_Object Procedure

USER_QUEUE_TABLES view : 5.6.2.1. The DBA_QUEUE_TABLES view

USER_QUEUES view

5.1.8. Data Dictionary Views

5.5.2.3. The DBMS_AQADM.ALTER_QUEUE procedure

users, distinguishing with DBMS_APPLICATION_INFO : 7.3.8. Session Monitoring and Three-Tier Architectures

UTL_FILE package

(see also files; specific program names)

1.2. Built-in Packages Covered in This Book

6.2. UTL_FILE: Reading and Writing Server-side Files

6.2.1.1. UTL_FILE programs

creating : 6.2.1. Getting Started with UTL_FILE

examples : 6.2.7. UTL_FILE Examples

exceptions

6.2.6.1. Handling file I/O errors

6.2.1.5. UTL_FILE exceptions

closing files and : 6.2.5.2. The UTL_FILE.FCLOSE_ALL procedure

GET_LINE enhancements for : 6.2.7.1. Enhancing UTL_FILE.GET_LINE

existence of files (example) : 6.2.7.2. Creating a file

format strings for PUTF : 6.2.4.4. The UTL_FILE.PUTF procedure

getting started : 6.2.1.2. Trying out UTL_FILE

I/O errors : 6.2.6.1. Handling file I/O errors

pathname support (enhancement) : 6.2.6.4. Adding support for paths

privileges

6.2.1. Getting Started with UTL_FILE

6.2.1.3. File security

processing flow : 6.2.1.8. The UTL_FILE process flow

programs contained in : 6.2.1.1. UTL_FILE programs

restrictions : 6.2.1.7. UTL_FILE restrictions and limitations

searching files (example) : 6.2.7.4. Searching a file for a string

string size maximum : 6.2.4. Writing to Files

tips on using : 6.2.6. Tips on Using UTL_FILE

UTL_RAW package

(see also raw data; specific program names)

1.2. Built-in Packages Covered in This Book

9.2. UTL_RAW: Manipulating Raw Data

9.2.1.1. UTL_RAW programs

bitmasks and : 9.2.2.3. Bit-fiddling

coercions : 9.2.2.1. Conversion and coercion

conversions

9.2.2.1. Conversion and coercion

9.2.3.5. The UTL_RAW.CAST_TO_RAW function

9.2.3.9. The UTL_RAW.CONVERT function

creating : 9.2.1. Getting Started with UTL_RAW

exceptions : 9.2.1.1. UTL_RAW programs

National Language Support and : 9.2. UTL_RAW: Manipulating Raw Data

programs contained in : 9.2.1.1. UTL_RAW programs

replication and : 9.2. UTL_RAW: Manipulating Raw Data

UTL_REF package

(see also specific program names)

1.2. Built-in Packages Covered in This Book

9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4)

9.2.4.1. Getting Started with UTL_REF

creating : 9.2.4.1. Getting Started with UTL_REF

example : 9.2.6. UTL_REF Example

exceptions : 9.2.4.1. Getting Started with UTL_REF

privileges : 9.2.4.1. Getting Started with UTL_REF

programs contained in : 9.2.4.1. Getting Started with UTL_REF

utlfile.sql script : 6.2.1. Getting Started with UTL_FILE

utlraw.sql script : 9.2.1. Getting Started with UTL_RAW

utlref.sql script : 9.2.4.1. Getting Started with UTL_REF

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.