You are previewing Oracle SQL: A Beginner’s Tutorial.
O'Reilly logo
Oracle SQL: A Beginner’s Tutorial

Book Description

A tutorial on Oracle SQL

Table of Contents

  1. Introduction
    1. SQL Overview
    2. About This Book
    3. Coding Convention
    4. Code Download
  2. Chapter 1
  3. Storing and Maintaining Data
    1. Selecting A Database to Use
    2. Creating a Table
    3. Adding Data
    4. Updating Data
    5. Deleting Data
    6. Summary
  4. Chapter 2
  5. Basic Queries
    1. The SELECT statement
    2. Querying All Data
    3. Selecting Specific Columns
    4. Selecting Rows with WHERE
    5. Compound Conditions
    6. Evaluation Precedence and the Use of Parentheses
    7. The NOT logical operator
    8. The BETWEEN Operator
    9. The IN Operator
    10. The LIKE Operator
    11. Escaping the Wildcard Character
    12. Combining the NOT operator
    13. Handling NULL
    14. Summary
  6. Chapter 3
  7. Query Output
    1. Column Aliases
    2. Expressions
    3. Limiting the Number of Rows
    4. The DISTINCT Keyword
    5. Aggregate Functions
    6. The CASE expression
    7. Ordering Output Rows
    8. Storing Query Output
    9. Summary
  8. Chapter 4
  9. Grouping
    1. The GROUP BY Clause
    2. The HAVING Keyword
    3. Summary
  10. Chapter 5
  11. Joins
    1. Primary Keys and Foreign Keys
    2. Querying Multiple Tables
    3. Using Table Aliases
    4. Joining More than Two Tables
    5. Outer Joins
    6. Self-Joins
    7. Multiple Uses of A Table
    8. Natural Joins
    9. Summary
  12. Chapter 6
  13. Subqueries
    1. Single-Row Subqueries
    2. Multiple-Row Subqueries
    3. Multiple Nested Subqueries
    4. Correlated Subqueries
    5. Summary
  14. Chapter 7
  15. Compound Queries
    1. UNION ALL
    2. UNION
    3. INTERSECT
    4. MINUS
    5. Summary
  16. Chapter 8
  17. Views
    1. Creating and Using Views
    2. Nested Views
    3. Managing Views
    4. Summary
  18. Chapter 9
  19. Built-in Functions
    1. Numeric Functions
    2. Character Functions
    3. Datetime Functions
    4. NULL-related functions
    5. Summary
  20. Chapter 10
  21. PL/SQL
    1. Row-by-row Processing
    2. If-Then-Else Decision Logic
    3. Exception Handling
    4. User-defined Functions
    5. Summary
  22. Chapter 11
  23. The Data Dictionary
    1. The Dictionary View
    2. The User_Catalog View
    3. The User_Tab_Cols View
    4. The User_Procedures View
    5. The User_Source View
    6. Summary
  24. Appendix A
  25. Installing Oracle Database XE
    1. Downloading Oracle Database XE
    2. Installing Oracle Database XE
    3. Creating a User with SQL*Plus
  26. Appendix B
  27. Oracle Built-in Data Types
  28. Appendix C
  29. Indexes
    1. Creating an Index
    2. Multi-Column Indexes
    3. Bitmap Indexes
    4. Bitmap Join Indexes
    5. Function-based Indexes
    6. Deleting An Index
    7. Summary