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.
|