Books & Videos

Table of Contents

  1. Chapter 1 Elements of SQL

    1. Lexical Conventions

    2. Naming in SQL

    3. Schema Objects

    4. Datatypes

    5. Data Conversion

    6. Relational Operators

    7. Structure of a SQL Statement

    8. SQL Statements

  2. Chapter 2 Data Definition Statements

    1. SQL DDL Statements by Task

    2. SQL Statement Syntax

  3. Chapter 3 Data Manipulation and Control Statements

    1. SQL DML and Control Statements by Task

    2. SQL Statement Syntax

  4. Chapter 4 Common SQL Elements

  5. Chapter 5 SQL Functions

    1. Aggregate Functions

    2. Numeric Functions

    3. Character Functions

    4. Date Functions

    5. Conversion Functions

    6. Other Functions

  6. Chapter 6 SQL*Plus

    1. Command-Line Syntax

    2. SQL*Plus Editing Commands

    3. Formatting SQL*Plus Output

    4. Miscellaneous SQL*Plus Commands

    5. SQL*Plus Variables and Related Commands

    6. SQL*Plus System Variables

  7. Chapter 7 PL/SQL

    1. The Structure of PL/SQL

    2. Block Header

    3. Declaration Section

    4. Execution Section

    5. Exception Section

    6. Procedures and Packages

    7. Triggers

  8. Chapter 8 SQL Statement Tuning

    1. Using EXPLAIN PLAN

    2. Using Oracle’s SQL Trace Facility

    3. SQL*Plus Tuning Aids

    4. Improving Query Performance

  1. Appendix SQL Resources

    1. Books

    2. Other Publications

    3. Organizations

    4. Web Sites

  2. Colophon