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

Index: T

table locks

6.1.5. The LOCK TABLE Statement

COMMIT statements and : 6.1.1. The COMMIT Statement

TABLE pseudo-function : 19.5.4. The TABLE Pseudo-function

TABLE type : 15.6.1.1. %TYPE and %ROWTYPE

table-based records : 9.2. Table-Based Records

TABLE_TO_COMMA procedure : C.16.11. The TABLE_TO_COMMA procedure

tables

(see also arrays; variables)

(see also collections)

1.4.3.4. PL/SQL tables

4. Variables and Program Data

10. PL/SQL Tables

19.1. Types of Collections

abbreviations for : 3.2. Formatting SQL Statements

aliases for : 3.2. Formatting SQL Statements

building arrays with : 10.9.4. Building Traditional Arrays with PL/SQL Tables

clearing (deleting) : 10.7. Clearing the PL/SQL Table

combining scalars and aggregates : 17.8.2. Combining Scalar and Aggregate Values

declaring : 10.4. Declaring a PL/SQL Table

displaying : 10.9.3. Displaying a PL/SQL Table

and DML statements : 10.3. PL/SQL Tables and DML Statements

filling rows of : 10.6. Filling the Rows of a PL/SQL Table

index-by : (see index-by tables)

inner tables : 19.1. Types of Collections

names for : 1.7.5. Structured Code and Other Best Practices

nested

(see nested tables)

1.4.7.3. Variable arrays and nested tables

objects for : 18.1.2. Some Simple Examples

optimizing foreign key lookups : 10.9.5. Optimizing Foreign Key Lookups with PL/SQL Tables

outer tables : 19.1. Types of Collections

as parameters : 10.5.4. Passing PL/SQL Tables as Parameters

partitioned, ROWID datatype for : 4.2.3.6. The ROWID datatype

PL/SQL : (see index-by tables)

records in : 10.8. PL/SQL Table Enhancements in PL/SQL Release 2.3

referencing rows : 10.5. Referencing and Modifying PL/SQL Table Rows

Release 2.3 enhancements to : 10.8. PL/SQL Table Enhancements in PL/SQL Release 2.3

returned from functions : 10.8.1.1. Referencing fields of record elements in PL/SQL tables

row index

data-smart : 10.9.2. Data-Smart Row Numbers in PL/SQL Tables

negative : 10.2. Characteristics of PL/SQL Tables

store tables : 19.1. Types of Collections

table objects

retrieving : 18.4.2.3. VALUE

VARRAYs : (see VARRAYs)

virtual : 6.2. Cursors in PL/SQL

tabs : (see whitespace)

TAN function : 13.1.20. The TAN function

TANH function : 13.1.21. The TANH function

target labels : 5.2.1.2. Target labels and scope of GOTO

terminating loops prematurely : 7.7.2. The Proper Way to Say Goodbye

testing

code : 24.2.5. Change and Test One Area of Code at a Time

object equality : 18.3.6.2. Equality comparisons

testing programs : 2.5.2. Multiline Comment Syntax

text

datatypes : 4.2.3. Character Datatypes

debugging messages in packages : 24.2.9. Build Debugging Messages into Your Packages

justifying : 11.2.3. Filling Text to Fit a Line

word wrap : 11.2.2. Implementing Word Wrap for Long Text

THE pseudo-function

19.5.1. The THE Pseudo-function

19.5.4. The TABLE Pseudo-function

THEN keyword : (see IF statements; WHEN clause)

time

(see also date)

C.16.6. The GET_TIME function

12.1.1. The ADD_MONTHS function

12.1.4. The NEW_TIME function

system : 12.1.7. The SYSDATE function

zones

12.1.4. The NEW_TIME function

12.2.2. Using NEW_TIME in Client-Server Environments

time zone, retrieving (example) : 21.7.1. Example: Retrieving the Time Zone

TIMEOUT_ON_RESOURCE exception : 8.3.1. Named System Exceptions

TO_CHAR function : 14.2.6. The TO_CHAR function (date conversion)

and date ranges : 14.3.4. Using TO_CHAR to Create a Date Range

TO_DATE function : 14.2.8. The TO_DATE function

and FX modifier : 14.3.2. FX: Matching Formats Exactly

TO_NUMBER function

14.2.9. The TO_NUMBER function

25.4.2. Zen and the Art of PL/SQL Tuning

toggles, in packages : 1.7.3. Center All Development Around Packages

TOO_MANY_ROWS exception : 8.3.1. Named System Exceptions

tracing PL/SQL execution : 26. Tracing PL/SQL Execution

transaction integrity

1.3.2. Improved Execution Authority and Transaction Integrity with PL/SQL

23.2. Transaction Integrity and Execute Authority

TRANSACTION_BACKED_OUT exception : 8.3.1. Named System Exceptions

transactions : 6.1. Transaction Management

comments with : 6.1.1. The COMMIT Statement

DBMS_TRANSACTION package for : C.15. DBMS_TRANSACTION

read-only : 6.1.4. The SET TRANSACTION Statement

TRANSLATE function

11.1.15. The TRANSLATE function

11.2.5. Verifying String Formats with TRANSLATE

25.4.2. Zen and the Art of PL/SQL Tuning

trapping errors : (see exceptions)

triggers

dropping : 20.3.2. DROP: Dropping Views and Triggers

size of : 25.3.7. Keep Database Triggers Small

trigonometric functions : (see functions, numeric)

TRIM procedure

C.6.15. The TRIM procedure

19.6.8. TRIM [ (n ) ]

removing collection elements with : 19.4.3.3. ...And what about TRIM?

TRUE : (see Boolean literals)

TRUNC function

12.1.6. The ROUND function

12.1.8. The TRUNC function

13.1.22. The TRUNC function

truncating dates : 12.1.8. The TRUNC function

truncating numbers : 13.1.22. The TRUNC function

Trusted Oracle : About the Contents

tuning PL/SQL applications : 25. Tuning PL/SQL Applications

access to compiled code : 25.2. Tuning Access to Compiled Code

access to data : 25.3. Tuning Access to Your Data

analyzing performance : 25.1. Analyzing Program Performance

optimizing algorithms : 25.4. Tuning Your Algorithms

TYPE ... RECORD statement : 9.4.1. Declaring Programmer-Defined Record TYPEs

%TYPE attribute

1.7.2. Synchronize Program and Data Structures

4.5. Anchored Declarations

4.7.7. Use %TYPE When a Variable Represents a Column

15.6.1.1. %TYPE and %ROWTYPE

TYPE declarations, in packages : 16.3. The Package Specification

type modifiers

18.2.3. Adding Complex Data Structures

REFs as : 18.4.2.2. REFs

TYPE statement

9.4.1. Declaring Programmer-Defined Record TYPEs

for tables : 10.4.1. Defining the Table TYPE

types, data : (see datatypes)

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