Apress

Mastering Oracle SQL and SQL*Plus

By Lex de Haan

Mastering Oracle SQL and SQL*Plus Cover Image

This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics.

Full Description

  • ISBN13: 978-1-59059-448-3
  • 488 Pages
  • User Level: Beginner to Advanced
  • Publication Date: January 3, 2005
  • Available eBook Formats: PDF
  • Print Book Price: $39.99
  • eBook Price: $27.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics. If you work with relational databases you need to understand the SQL language. And you will gain full competence to define, access, and manipulate data in an Oracle database, if you do so following this book's guidance.

This book is fully compliant with the latest version of the ANSI SQL standard, and fully updated for the Oracle 10g database. Furthermore, this book is based on a popular Netherlands college textbook (currently in its third edition). And author Lex de Haan is vastly experienced with the Oracle database, and has 25 years of teaching experience. de Haan is also a member of the ANSI/ISO SQL standardization national body.

Table of Contents

Table of Contents

  1. Relational Database Systems and Oracle
  2. Introduction to SQL, iSQL*Plus, and SQL*Plus
  3. Data Definition, Part I
  4. Retrieval: The Basics
  5. Retrieval: Functions
  6. Data Manipulation
  7. Data Definition, Part II
  8. Retrieval: Multiple Tables and Aggregation
  9. Retrieval: Some Advanced Features
  10. Views
  11. SQL*Plus and iSQL*Plus
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

No errata are currently published