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

UI templates library, WebDB: 3.1.2.3. Building shared components, Oracle Web Applications
UID function: 13.3.7. The UID function, Oracle PL/SQL Programming
UML (Unified Modeling Lanuage): 18.1.4.3. Inheritance , Oracle PL/SQL Programming
UNIQUE_SESSION_ID function
11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.3.2. The DBMS_SESSION.UNIQUE_SESSION_ID function, Oracle Built-in Packages
C.12.9. The UNIQUE_SESSION_ID function, Oracle PL/SQL Programming
UNIQUE_SESSION_NAME function
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.3.5. The DBMS_PIPE.UNIQUE_SESSION_NAME function, Oracle Built-in Packages
C.10.9. The UNIQUE_SESSION_NAME function, Oracle PL/SQL Programming
UNIQUE_SESSION_ID versus: 11.1.3.2. The DBMS_SESSION.UNIQUE_SESSION_ID function, Oracle Built-in Packages
UNIX delimiter
5.11.1. Package constants and exceptions, Advanced Oracle PL/SQL Programming with Packages
13.2.1. Setting the Operating System Delimiter, Advanced Oracle PL/SQL Programming with Packages
UNKEEP procedure
12.2.1. Getting Started with DBMS_SHARED_POOL, Oracle Built-in Packages
12.2.2.2. The DBMS_SHARED_POOL.UNKEEP procedure, Oracle Built-in Packages
UNKEEP program: 1.4.3.1. Managing packages in shared memory, Advanced Oracle PL/SQL Programming with Packages
UNPACK_MESSAGE procedure
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.4.4. The DBMS_PIPE.UNPACK_MESSAGE procedure, Oracle Built-in Packages
C.10.10. The UNPACK_MESSAGE procedure, Oracle PL/SQL Programming
UNPACK_MESSAGE_RAW procedure
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.4.5. The DBMS_PIPE.UNPACK_MESSAGE_RAW procedure, Oracle Built-in Packages
UNPACK_MESSAGE_ROWID procedure
3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.4.6. The DBMS_PIPE.UNPACK_MESSAGE_ROWID procedure, Oracle Built-in Packages
UNREGISTER_PROPAGATOR procedure
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.6.9. The DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR procedure (Oracle8 only), Oracle Built-in Packages
UNREGISTER_SNAPSHOT procedure
14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
14.1.6.2. The DBMS_SNAPSHOT.UNREGISTER_SNAPSHOT procedures (Oracle8 only), Oracle Built-in Packages
UNSCHEDULE_EXECUTION procedure
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.5.4. The DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION procedure, Oracle Built-in Packages
UNSCHEDULE_PROPAGATION procedure
5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.5.2. The DBMS_AQADM.UNSCHEDULE_PROPAGATION procedure , Oracle Built-in Packages
UNSCHEDULE_PURGE procedure
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.6.6. The DBMS_DEFER_SYS.UNSCHEDULE_PURGE procedure (Oracle8 only), Oracle Built-in Packages
UNSCHEDULE_PUSH procedure
17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.6.7. The DBMS_DEFER_SYS.UNSCHEDULE_PUSH procedure (Oracle8 only), Oracle Built-in Packages
UNUSED_SPACE procedure
12.1.1. Getting Started with DBMS_SPACE, Oracle Built-in Packages
12.1.2.2. The DBMS_SPACE.UNUSED_SPACE procedure, Oracle Built-in Packages
UPD column, *_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
UPDATE statement
(see also DML statements)
19.5.3. Executing dynamic UPDATEs, Advanced Oracle PL/SQL Programming with Packages
3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming
10.3. PL/SQL Tables and DML Statements, Oracle PL/SQL Programming
array processing and: 2.5.6.3. Using array processing to update, Oracle Built-in Packages
THE function with: 19.5.1. The THE Pseudo-function, Oracle PL/SQL Programming
WHERE CURRENT OF clause: 6.11.2. The WHERE CURRENT OF Clause, Oracle PL/SQL Programming
UPDATE_OBJECT procedure: 9.2.5.4. The UTL_REF.UPDATE_OBJECT procedure, Oracle Built-in Packages
UPPER function: 11.1.16. The UPPER function, Oracle PL/SQL Programming
URLs: 2.2.5. The Uniform Resource Locator, Oracle Web Applications
WebDB dashboard: 3.1.3.1. User-uploaded content, Oracle Web Applications
USER function: 13.3.8. The USER function, Oracle PL/SQL Programming
USERENV function: 13.3.9. The USERENV function, Oracle PL/SQL Programming
USER_DEPENDENCIES view
18.2.1. Knowing What You've Got, Advanced Oracle PL/SQL Programming with Packages
23.6.1. Displaying Object Dependencies, Oracle PL/SQL Programming
USER_ERRORS view
9.6.2. Examining Loaded Java Elements, Guide to Oracle8i Features
15.1.2. What SHOW ERRORS Does, Advanced Oracle PL/SQL Programming with Packages
USER_EXPORT procedure
13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
13.2.8.1. The DBMS_JOB.USER_EXPORT procedure, Oracle Built-in Packages
C.5.9. The USER_EXPORT procedure, Oracle PL/SQL Programming
USER_JOBS view: 13.3.2. Viewing Job Information in the Data Dictionary, Oracle Built-in Packages
USER_OBJECTS view
9.6.2. Examining Loaded Java Elements, Guide to Oracle8i Features
2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages
23.6.2. Displaying Information About Stored Objects, Oracle PL/SQL Programming
USER_OBJECT_SIZE view
1.4.3.1. Managing packages in shared memory, Advanced Oracle PL/SQL Programming with Packages
23.6.3. Analyzing the Size of PL/SQL Code, Oracle PL/SQL Programming
USER_POLICIES data dictionary view: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
USER_QUEUES view
5.1.8. Data Dictionary Views, Oracle Built-in Packages
5.5.2.3. The DBMS_AQADM.ALTER_QUEUE procedure, Oracle Built-in Packages
USER_QUEUE_TABLES view: 5.6.2.1. The DBA_QUEUE_TABLES view, Oracle Built-in Packages
USER_SOURCE view
5.15.4. Managing the source repository, Advanced Oracle PL/SQL Programming with Packages
18.2.1. Knowing What You've Got, Advanced Oracle PL/SQL Programming with Packages
17.5.2. Locating Text in the Data Dictionary, Advanced Oracle PL/SQL Programming with Packages
23.6.4. Displaying and Searching Source Code, Oracle PL/SQL Programming
9.6.2. Examining Loaded Java Elements, Guide to Oracle8i Features
USE_ROLLBACK_SEGMENT procedure
4.2.1.1. DBMS_TRANSACTION programs, Oracle Built-in Packages
4.2.4.5. The DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT procedure, Oracle Built-in Packages
C.15.13. The USE_ROLLBACK_SEGMENT procedure, Oracle PL/SQL Programming
USING clause
4.2.2. The OPEN FOR Statement, Guide to Oracle8i Features
4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
4.3.2. The USING Clause in OPEN FOR, Guide to Oracle8i Features
UTLBSTAT, UTLESTAT scripts: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming
UTL_FILE package
(see also specific program names)
1.5.1. Builtin Packages, Advanced Oracle PL/SQL Programming with Packages
5.11. PLVfile: Operating System I/O Manager, Advanced Oracle PL/SQL Programming with Packages
13. PLVfile: Reading and Writing Operating System Files, Advanced Oracle PL/SQL Programming with Packages
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
6.2. UTL_FILE: Reading and Writing Server-side Files, Oracle Built-in Packages
6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
9.9.1. Extending File I/O Capabilities, Guide to Oracle8i Features
C.17. UTL_FILE, Oracle PL/SQL Programming
I/O errors: 6.2.6.1. Handling file I/O errors, Oracle Built-in Packages
creating: 6.2.1. Getting Started with UTL_FILE, Oracle Built-in Packages
examples: 6.2.7. UTL_FILE Examples, Oracle Built-in Packages
exceptions
6.2.6.1. Handling file I/O errors, Oracle Built-in Packages
6.2.1.5. UTL_FILE exceptions, Oracle Built-in Packages
GET_LINE enhancements for: 6.2.7.1. Enhancing UTL_FILE.GET_LINE, Oracle Built-in Packages
closing files and: 6.2.5.2. The UTL_FILE.FCLOSE_ALL procedure, Oracle Built-in Packages
existence of files (example): 6.2.7.2. Creating a file, Oracle Built-in Packages
format strings for PUTF: 6.2.4.4. The UTL_FILE.PUTF procedure, Oracle Built-in Packages
getting started: 6.2.1.2. Trying out UTL_FILE, Oracle Built-in Packages
pathname support (enhancement): 6.2.6.4. Adding support for paths, Oracle Built-in Packages
privileges
6.2.1. Getting Started with UTL_FILE, Oracle Built-in Packages
6.2.1.3. File security, Oracle Built-in Packages
processing flow: 6.2.1.8. The UTL_FILE process flow, Oracle Built-in Packages
programs contained in: 6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
restrictions: 6.2.1.7. UTL_FILE restrictions and limitations, Oracle Built-in Packages
searching files (example): 6.2.7.4. Searching a file for a string, Oracle Built-in Packages
string size maximum: 6.2.4. Writing to Files, Oracle Built-in Packages
tips on using: 6.2.6. Tips on Using UTL_FILE, Oracle Built-in Packages
UTL_RAW package
(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
9.2. UTL_RAW: Manipulating Raw Data, Oracle Built-in Packages
9.2.1.1. UTL_RAW programs, Oracle Built-in Packages
National Language Support and: 9.2. UTL_RAW: Manipulating Raw Data, Oracle Built-in Packages
bitmasks and: 9.2.2.3. Bit-fiddling, Oracle Built-in Packages
coercions: 9.2.2.1. Conversion and coercion, Oracle Built-in Packages
conversions
9.2.2.1. Conversion and coercion, Oracle Built-in Packages
9.2.3.5. The UTL_RAW.CAST_TO_RAW function, Oracle Built-in Packages
9.2.3.9. The UTL_RAW.CONVERT function, Oracle Built-in Packages
creating: 9.2.1. Getting Started with UTL_RAW, Oracle Built-in Packages
exceptions: 9.2.1.1. UTL_RAW programs, Oracle Built-in Packages
programs contained in: 9.2.1.1. UTL_RAW programs, Oracle Built-in Packages
replication and: 9.2. UTL_RAW: Manipulating Raw Data, Oracle Built-in Packages
UTL_REF package
(see also specific program names)
1.2. Built-in Packages Covered in This Book, Oracle Built-in Packages
9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4), Oracle Built-in Packages
9.2.4.1. Getting Started with UTL_REF, Oracle Built-in Packages
creating: 9.2.4.1. Getting Started with UTL_REF, Oracle Built-in Packages
example: 9.2.6. UTL_REF Example, Oracle Built-in Packages
exceptions: 9.2.4.1. Getting Started with UTL_REF, Oracle Built-in Packages
privileges: 9.2.4.1. Getting Started with UTL_REF, Oracle Built-in Packages
programs contained in: 9.2.4.1. Getting Started with UTL_REF, Oracle Built-in Packages
Unified Modeling Lanuage: 18.1.4.3. Inheritance , Oracle PL/SQL Programming
unconstrained datatypes: 4.6. Programmer-Defined Subtypes, Oracle PL/SQL Programming
unconstrained declaration: (see parameters)
undefined table rows: 10.5.2. Referencing an Undefined Row, Oracle PL/SQL Programming
underscore (_): 5.7.5.1. Wildcarded correlation identifiers, Oracle Built-in Packages
unhandled exceptions: (see exceptions)
uninstalling PL/SQL: 4.4.5. Uninstalling PL/Vision, Advanced Oracle PL/SQL Programming with Packages
unique_id function
11.1.5.1. Adding value to DBMS_SESSION, Oracle Built-in Packages
11.1.5.2. The unique_id function, Oracle Built-in Packages
uniqueness conflicts
(see also insert conflicts)
16.5.1. About Resolution Methods, Oracle Built-in Packages
resolution methods: 16.5.1. About Resolution Methods, Oracle Built-in Packages
unlocking records: 6.11.1. Releasing Locks with COMMIT, Oracle PL/SQL Programming
unmodifiable views: 6.1. Triggers on Nested Table View Columns, Guide to Oracle8i Features
unnamed constants: (see literals)
unpack_all_items procedure: 3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function, Oracle Built-in Packages
unpack_to_tbl procedure: 3.1.7.3. The dbpipe utility package, Oracle Built-in Packages
unpinning code from memory: 1.4.3.1. Managing packages in shared memory, Advanced Oracle PL/SQL Programming with Packages
unqualified package references: 1.4.2.1. Unqualified package references, Advanced Oracle PL/SQL Programming with Packages
unused_blocks function: 12.1.3.1. The segspace package, Oracle Built-in Packages
upcexc package: 22.2.1.2. Tired fingers, buggy code, Advanced Oracle PL/SQL Programming with Packages
upd function: 10.2.3.2. Using psdesc.args as a quality assurance tool, Oracle Built-in Packages
updarray.sp : 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
update conflicts: 16. Conflict Resolution, Oracle Built-in Packages
dropping priority groups and conflict resolution: 16.3.2.2. The DBMS_REPCAT.DROP_PRIORITY_GROUP procedure, Oracle Built-in Packages
resolution methods: 16.5.1. About Resolution Methods, Oracle Built-in Packages
update_check parameter, ADD_POLICY procedure: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features
update_row procedure: 7.3.9. Tracking Long-Running Processes, Oracle Built-in Packages
upddelist.sp : 10.1.2.4. The DBMS_UTILITY.COMMA_TO_TABLE procedure, Oracle Built-in Packages
upgrading code: 1.6.1.6. Hide weaknesses to facilitate upgrades and fixes., Advanced Oracle PL/SQL Programming with Packages
upper_bound, FORALL statement: 5.2. Bulk DML with the FORALL Statement, Guide to Oracle8i Features
uppercase: (see case)
usage: (see performance analysis)
use subdirectory
4.3.3. Beginning the Installation, Advanced Oracle PL/SQL Programming with Packages
4.6.3. Contents of the use Subdirectory, Advanced Oracle PL/SQL Programming with Packages
usecmnt procedure: 16.3.6. Generating Comments, Advanced Oracle PL/SQL Programming with Packages
usecor procedure: 16.3.9. Including CREATE OR REPLACE, Advanced Oracle PL/SQL Programming with Packages
useexc procedure: 16.3.5. Using the PLVexc Exception Handler, Advanced Oracle PL/SQL Programming with Packages
usehdr procedure: 16.3.3. Using the Program Header, Advanced Oracle PL/SQL Programming with Packages
usehlp procedure: 16.3.7. Generating Online Help Text Stubs, Advanced Oracle PL/SQL Programming with Packages
useln procedure: 16.3.8. Generating Line Numbers, Advanced Oracle PL/SQL Programming with Packages
usemax procedure: 16.3.10. Setting Groups of Toggles, Advanced Oracle PL/SQL Programming with Packages
usemin procedure: 16.3.10. Setting Groups of Toggles, Advanced Oracle PL/SQL Programming with Packages
user accounts: (see advanced replication, user accounts)
user queues: 5.1.5. A Glossary of Terms, Oracle Built-in Packages
user role (AQ): 5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
user-defined exception: 7.2.4. Format of Collected Data , Guide to Oracle8i Features
user-defined objects: 4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features
user-level events: 6.3. Schema-Level Event Triggers, Guide to Oracle8i Features
users: 2.5.1. Seeing Developers as Users, Advanced Oracle PL/SQL Programming with Packages
PLVdyn and: 19.5.10. Executing PLVdyn in Different Schemas, Advanced Oracle PL/SQL Programming with Packages
awareness of literals: 2.5.3. Avoiding Need for User to Know and Pass Literals, Advanced Oracle PL/SQL Programming with Packages
customizing program for: 2.8.1.2. Fitting the program to the user , Advanced Oracle PL/SQL Programming with Packages
database
2.5.1. Database Users, Oracle Web Applications
3.1.1.2. Administer WebDB and database security, Oracle Web Applications
distinguishing with DBMS_APPLICATION_INFO: 7.3.8. Session Monitoring and Three-Tier Architectures, Oracle Built-in Packages
ID number of: 13.3.7. The UID function, Oracle PL/SQL Programming
name of: 13.3.8. The USER function, Oracle PL/SQL Programming
session: 13.3.9. The USERENV function, Oracle PL/SQL Programming
sharing PL/Vision: 4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
user interface: 3.4. Improving the User Interface, Advanced Oracle PL/SQL Programming with Packages
usetrc procedure: 16.3.4. Using the Program Trace , Advanced Oracle PL/SQL Programming with Packages
using_cmnt function: 16.3.6. Generating Comments, Advanced Oracle PL/SQL Programming with Packages
using_cor function: 16.3.9. Including CREATE OR REPLACE, Advanced Oracle PL/SQL Programming with Packages
using_exc function: 16.3.5. Using the PLVexc Exception Handler, Advanced Oracle PL/SQL Programming with Packages
using_hdr function: 16.3.3. Using the Program Header, Advanced Oracle PL/SQL Programming with Packages
using_hlp function: 16.3.7. Generating Online Help Text Stubs, Advanced Oracle PL/SQL Programming with Packages
using_ln function: 16.3.8. Generating Line Numbers, Advanced Oracle PL/SQL Programming with Packages
using_trc function: 16.3.4. Using the Program Trace , Advanced Oracle PL/SQL Programming with Packages
usrc 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
utility modules
C.16. DBMS_UTILITY, Oracle PL/SQL Programming
24.2.8. Leverage Existing Utilities -- Or Build Your Own, Oracle PL/SQL Programming
for analyzing performance: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming
utility packages
4.7. NDS Utility Package, Guide to Oracle8i Features
1.5.2. Prebuilt Packages, Advanced Oracle PL/SQL Programming with Packages
utlfile.sql script: 6.2.1. Getting Started with UTL_FILE, Oracle Built-in Packages
utlraw.sql script: 9.2.1. Getting Started with UTL_RAW, Oracle Built-in Packages
utlref.sql script: 9.2.4.1. Getting Started with UTL_REF, Oracle Built-in Packages

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.