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
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.