Oracle Database 10g SQL (Osborne ORACLE Press Series)

Chapter 1: Introduction

Table 1-1: Commonly Used Oracle Data Types

Table 1-2: Special Values

Chapter 3: Using Simple Functions

Table 3-1: Character Functions

Table 3-2: Numeric Functions

Table 3-3: Conversion Functions

Table 3-4: Format Parameters

Table 3-5: Regular Expression Metacharacters

Table 3-6: Regular Expression Functions

Table 3-7: Aggregate Functions

Chapter 4: Storing and Processing Dates and Times

Table 4-1: TO_CHAR() and TO_DATE() Conversion Functions

Table 4-2: Datetime Formatting Parameters

Table 4-3: How Two-Digit Years Are Interpreted

Table 4-4: Datetime Functions

Table 4-5: Time ZoneRelated Functions

Table 4-6: Timestamp Types

Table 4-7: Timestamp-Related Functions

Table 4-8: Time Interval Types

Table 4-9: Time IntervalRelated Functions

Chapter 7: Advanced Queries

Table 7-1: Set Operators

Table 7-2: Ranking Functions

Chapter 8: Changing Table Contents

Table 8-1: Concurrent Transactions

Table 8-2: Serializable Transactions

Chapter 9: Database Security

Table 9-1: Commonly Used System Privileges

Table 9-2: Some Columns in user_sys_privs

Table 9-3: Commonly Used Object Privileges

Table 9-4: Some Columns in user_tab_privs_made

Table 9-5: Some Columns in user_col_privs_made

Table 9-6: Some Columns in user_tab_privs_recd

Table 9-7: Some Columns in user_col_privs_recd

Table 9-8: Roles to be Created

Table 9-9: Some Columns in user_role_privs

Table 9-10: Some Columns in role_sys_privs

Table 9-11: Some Columns in role_tab_privs

Chapter 10: Creating Tables, Sequences, Indexes, and Views

Table 10-1: Some Columns in user_tables

Table 10-2: Some Columns in user_tab_columns

Table 10-3: Constraints

Table 10-4: Some Columns in user_constraints

Table 10-5: Some Columns in user_cons_columns

Table 10-6: Some Columns in user_sequences

Table 10-7: Some Columns in user_indexes

Table 10-8: Some Columns in user_ind_columns

Table 10-9: Some Columns in user_views

Chapter 11: Introducing PL/SQL Programming

Table 11-1: Predefined Exceptions

Table 11-2: Some Columns in user_procedures

Table 11-3: Some Columns in user_triggers

Chapter 13: Collections

Table 13-1: Some Columns in user_varrays

Table 13-2: Some Columns in user_nested_tables

Table 13-3: Collection Methods

Chapter 14: Large Objects

Table 14-1: DBMS_LOB Methods

Table 14-2: Exceptions Thrown by READ()

Table 14-3: Exceptions Thrown by WRITE()

Table 14-4: Exception Thrown by APPEND()

Table 14-5: Exceptions Thrown by COMPARE()

Table 14-6: Exceptions Thrown by COPY()

Table 14-7: Exception Thrown by CREATETEMPORARY()

Table 14-8: Exceptions Thrown by ERASE()

Table 14-9: Exceptions Thrown by FILECLOSE()

Table 14-10: Exception Thrown by FILECLOSEALL()

Table 14-11: Exceptions Thrown by FILEEXISTS()

Table 14-12: Exceptions Thrown by FILEGETNAME()

Table 14-13: Exceptions Thrown by FILEISOPEN()

Table 14-14: Exceptions Thrown by FILEOPEN()

Table 14-15: Exception Thrown by FREETEMPORARY()

Table 14-16: Exception Thrown by GETCHUNKSIZE()

Table 14-17: Exception Thrown by GETLENGTH()

Table 14-18: Exception Thrown by INSTR()

Table 14-19: Exception Thrown by ISOPEN()

Table 14-20: Exception Thrown by ISTEMPORARY()

Table 14-21: Exceptions Thrown by LOADFROMFILE()

Table 14-22: Exceptions Thrown by LOADBLOBFROMFILE()

Table 14-23: Exceptions Thrown by LOADCLOBFROMFILE()

Table 14-24: Exception Thrown by OPEN()

Table 14-25: Exceptions Thrown by SUBSTR()

Table 14-26: Exceptions Thrown by TRIM()

Table 14-27: Exceptions Thrown by WRITEAPPEND()

Chapter 15: Running SQL Using Java

Table 15-1: DataSource Attributes

Table 15-2: OracleDataSource Attributes

Table 15-3: Compatible Type Mappings

Table 15-4: short, int, and long Types

Table 15-5: float and double Types

Table 15-6: Classes and Compatible Oracle Database Types

Table 15-7: Classes and Interfaces of the oracle.jdbc Package

Chapter 16: High Performance SQL Tuning

Table 16-1: Plan Table Columns

Table 16-2: Execution Plan Operations

Appendix: Oracle Data Types

Table A-1: Oracle SQL Types

Table A-2: Oracle PL/SQL Types