Index

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


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