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
• • The LOCK TABLE Statement
  • COMMIT statements and : The COMMIT Statement
• TABLE pseudo-function : The TABLE Pseudo-function
• TABLE type : %TYPE and %ROWTYPE
• table-based records : Table-Based Records
• TABLE_TO_COMMA procedure : The TABLE_TO_COMMA procedure
• tables
• • (see also arrays; variables)
  • (see also collections)
  • PL/SQL tables
  • Variables and Program Data
  • PL/SQL Tables
  • Types of Collections
  • abbreviations for : Formatting SQL Statements
  • aliases for : Formatting SQL Statements
  • building arrays with : Building Traditional Arrays with PL/SQL Tables
  • clearing (deleting) : Clearing the PL/SQL Table
  • combining scalars and aggregates : Combining Scalar and Aggregate Values
  • declaring : Declaring a PL/SQL Table
  • displaying : Displaying a PL/SQL Table
  • and DML statements : PL/SQL Tables and DML Statements
  • filling rows of : Filling the Rows of a PL/SQL Table
  • index-by : (see index-by tables)
  • inner tables : Types of Collections
  • names for : Structured Code and Other Best Practices
  • nested
  • • (see nested tables)
    • Variable arrays and nested tables
    • objects for : Some Simple Examples
  • optimizing foreign key lookups : Optimizing Foreign Key Lookups with PL/SQL Tables
  • outer tables : Types of Collections
  • as parameters : Passing PL/SQL Tables as Parameters
  • partitioned, ROWID datatype for : The ROWID datatype
  • PL/SQL : (see index-by tables)
  • records in : PL/SQL Table Enhancements in PL/SQL Release 2.3
  • referencing rows : Referencing and Modifying PL/SQL Table Rows
  • Release 2.3 enhancements to : PL/SQL Table Enhancements in PL/SQL Release 2.3
  • returned from functions : Referencing fields of record elements in PL/SQL tables
  • row index
  • • data-smart : Data-Smart Row Numbers in PL/SQL Tables
    • negative : Characteristics of PL/SQL Tables
  • store tables : Types of Collections
  • table objects
  • • retrieving : VALUE
  • VARRAYs : (see VARRAYs)
  • virtual : Cursors in PL/SQL
• tabs : (see whitespace)
• TAN function : The TAN function
• TANH function : The TANH function
• target labels : Target labels and scope of GOTO
• terminating loops prematurely : The Proper Way to Say Goodbye
• testing
• • code : Change and Test One Area of Code at a Time
  • object equality : Equality comparisons
• testing programs : Multiline Comment Syntax
• text
• • datatypes : Character Datatypes
  • debugging messages in packages : Build Debugging Messages into Your Packages
  • justifying : Filling Text to Fit a Line
  • word wrap : Implementing Word Wrap for Long Text
• THE pseudo-function
• • The THE Pseudo-function
  • The TABLE Pseudo-function
• THEN keyword : (see IF statements; WHEN clause)
• time
• • (see also date)
  • The GET_TIME function
  • The ADD_MONTHS function
  • The NEW_TIME function
  • system : The SYSDATE function
  • zones
  • • The NEW_TIME function
    • Using NEW_TIME in Client-Server Environments
• time zone, retrieving (example) : Example: Retrieving the Time Zone
• TIMEOUT_ON_RESOURCE exception : Named System Exceptions
• TO_CHAR function : The TO_CHAR function (date conversion)
• • and date ranges : Using TO_CHAR to Create a Date Range
• TO_DATE function : The TO_DATE function
• • and FX modifier : FX: Matching Formats Exactly
• TO_NUMBER function
• • The TO_NUMBER function
  • Zen and the Art of PL/SQL Tuning
• toggles, in packages : Center All Development Around Packages
• TOO_MANY_ROWS exception : Named System Exceptions
• tracing PL/SQL execution : Tracing PL/SQL Execution
• transaction integrity
• • Improved Execution Authority and Transaction Integrity with PL/SQL
  • Transaction Integrity and Execute Authority
• TRANSACTION_BACKED_OUT exception : Named System Exceptions
• transactions : Transaction Management
• • comments with : The COMMIT Statement
  • DBMS_TRANSACTION package for : DBMS_TRANSACTION
  • read-only : The SET TRANSACTION Statement
• TRANSLATE function
• • The TRANSLATE function
  • Verifying String Formats with TRANSLATE
  • Zen and the Art of PL/SQL Tuning
• trapping errors : (see exceptions)
• triggers
• • dropping : DROP: Dropping Views and Triggers
  • size of : Keep Database Triggers Small
• trigonometric functions : (see functions, numeric)
• TRIM procedure
• • The TRIM procedure
  • TRIM [ (n ) ]
  • removing collection elements with : And what about TRIM?
• TRUE : (see Boolean literals)
• TRUNC function
• • The ROUND function
  • The TRUNC function
  • The TRUNC function
• truncating dates : The TRUNC function
• truncating numbers : The TRUNC function
• Trusted Oracle : About the Contents
• tuning PL/SQL applications : Tuning PL/SQL Applications
• • access to compiled code : Tuning Access to Compiled Code
  • access to data : Tuning Access to Your Data
  • analyzing performance : Analyzing Program Performance
  • optimizing algorithms : Tuning Your Algorithms
• TYPE ... RECORD statement : Declaring Developer-Defined Record TYPEs
• %TYPE attribute
• • Synchronize Program and Data Structures
  • Anchored Declarations
  • Use %TYPE When a Variable Represents a Column
  • %TYPE and %ROWTYPE
• TYPE declarations, in packages : The Package Specification
• type modifiers
• • Adding Complex Data Structures
  • REFs as : REFs
• TYPE statement
• • Declaring Developer-Defined Record TYPEs
  • for tables : Defining the Table TYPE
• types, data : (see datatypes)