Book HomeBook HomeSearch this book

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

TABLE_TO_COMMA procedure
10.1.1. Getting Started with DBMS_UTILITY
10.1.2.20. The DBMS_UTILITY.TABLE_TO_COMMA procedure
tables
analyzing : 13.4.1. Tracking Space in Tablespaces
AQ and : 5.1.1. General Features
displaying contents of (example) : 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL
memory use and : 11.1.4.2. The DBMS_SESSION.FREE_UNUSED_USER_MEMORY procedure
referenceability : 10.3.4. Setting Referenceability of Tables
reorganizing : 14.1.5. Reorganizing Tables
replacing (example) : 10.3.4.1. The DBMS_DDL. (Oracle8 only)
replicated tables
comparing : 15.5.2.1. The DBMS_RECTIFIER.DIFFERENCES procedure
dropping and replication triggers : 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure
instantiation versus rectifying : 15.5.2.2. The DBMS_RECTIFIER_DIFF.RECTIFY procedure
rectifying : 15.5.2.2. The DBMS_RECTIFIER_DIFF.RECTIFY procedure
space utilization : 12.1. DBMS_SPACE: Obtaining Space Information
tabpkg package
(see also specific program names)
6.2.7.1. Enhancing UTL_FILE.GET_LINE
tabref.sql : 10.3.4.1. The DBMS_DDL. (Oracle8 only)
TERMINATE procedure
10.4.1. Getting Started with DBMS_RANDOM
10.4.2.4. The DBMS_RANDOM.TERMINATE procedure (Oracle8 only)
territory (NLS), setting : 11.1.2.3. The DBMS_SESSION.SET_NLS procedure
testing : (see debugging; tracing; troubleshooting)
time, elapsed time : 10.1.2.14. The DBMS_UTILITY.GET_TIME function
timeouts
3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function
3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function
3.1.6.4. Paying attention to timeouts
toggling bits : 9.2.3.4. The UTL_RAW.BIT_XOR function
total_blocks function : 12.1.3.1. The segspace package
trace event levels : (see tracing, event levels)
trace package
(see also specific program names)
1.3.5.1. Examples of encapsulation packages
11.2.3. DBMS_SYSTEM Examples
trace.sql : 11.2.3. DBMS_SYSTEM Examples
tracing
(see also debugging; troubleshooting)
11.1.4.5. The DBMS_SESSION.SET_SQL_TRACE procedure
11.2. DBMS_System: Setting Events for Debugging
enabling/disabling in another session : 11.2.2.3. The DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure
enabling/disabling in same session : 11.1.4.5. The DBMS_SESSION.SET_SQL_TRACE procedure
encapsulating DBMS_SYSTEM : 11.2.3. DBMS_SYSTEM Examples
enhancement : 11.1.5.6. The set_sql_trace procedure
event levels
reading : 11.2.2.1. The DBMS_SYSTEM.READ_EV procedure
setting : 11.2.2.2. The DBMS_SYSTEM.SET_EV procedure
reasons for using : 7.3.8. Session Monitoring and Three-Tier Architectures
SQL statements with packaged functions : 1.3.7.2. Using a packaged procedure from within SQL
TRANSACTION procedure (DBMS_DEFER)
17.3.1.1. DBMS_DEFER programs
17.3.2.1. The DBMS_DEFER.TRANSACTION procedure
transaction statements, programmatic interface to : 4.2. DBMS_TRANSACTION: Interfacing to SQL Transaction Statements
transactions
(see also deferred transactions)
7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure
action names : (see action names)
alerts and
3.2.2.5. The DBMS_ALERT.SIGNAL procedure
3.2.3. DBMS_ALERT Examples
characteristics of : 4.2.5. Setting Transaction Characteristics
cleaning up : 4.2.6. Cleaning Up Transaction Details
commitment : 4.2.3. Committing Data
concentrating via DBMS_PIPE : 3.1.7.4. Implementing a server program
current transaction : 7.2.3. The DBMS_APPLICATION_INFO.SET_ACTION procedure
dequeuing and
5.1.3. Dequeue Features
5.3.8. Dequeue Options Record Type
discrete transactions : 4.2.5.3. The DBMS_TRANSACTION.BEGIN_DISCRETE_TRANSACTION procedure
enqueuing and
5.1.3. Dequeue Features
5.3.7. Enqueue Options Record Type
identifiers for : 4.2.7.1. The DBMS_TRANSACTION.LOCAL_TRANSACTION_ID function
in-doubt transactions : (see in-doubt transactions)
intersession communication and : 3.1. DBMS_PIPE: Communicating Between Sessions
LOBs and : 8.2.1.1. Internal and external LOBs
lock persistence and : 4.1.2.2. The DBMS_LOCK.REQUEST function
pipes and : 3.1.2.2. Nontransactional communications
read-only : 4.2.5.1. The DBMS_TRANSACTION.READ_ONLY procedure
read-write : 4.2.5.2. The DBMS_TRANSACTION.READ_WRITE procedure
recovery : 4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure
rollback : 4.2.4. Rolling Back Changes
short transactions : 4.2.5.3. The DBMS_TRANSACTION.BEGIN_DISCRETE_TRANSACTION procedure
step id : 4.2.7.2. The DBMS_TRANSACTION.STEP_ID function
transid.sql : 4.2.7.2. The DBMS_TRANSACTION.STEP_ID function
TRANSLATE function : 9.2.3.15. The UTL_RAW.TRANSLATE function
TRANSLITERATE function : 9.2.3.16. The UTL_RAW.TRANSLITERATE function
triggers
alert signaling and : 3.2. DBMS_ALERT: Broadcasting Alerts to Users
allocating locks and : 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure
named locks and : 4.1.3.4. ALLOCATE_UNIQUE drawbacks
National Language Support parameters and : 11.1.2.3. The DBMS_SESSION.SET_NLS procedure
replication triggers : (see replication triggers)
roles and : 11.1.2.4. The DBMS_SESSION.SET_ROLE procedure
TRIM procedure
8.1.1. DBMS_LOB Programs
8.3.3.4. The DBMS_LOB.TRIM procedure
troubleshooting
(see also debugging; tracing)
2.3.10.3. The DBMS_SQL.LAST_ROW_ID function
dynamic SQL : 2.4.6. Problem-Solving Dynamic SQL Errors
EXECUTE_AND_FETCH : 2.3.8. Retrieving Values
Trusted Oracle, job execution and : 13.2.2. Job Execution and the Job Execution Environment
two-phase commit : (see distributed databases; in-doubt transactions)
typing : (see datatypes)


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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference