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

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