Skip to main content
SpringerLink
Log in
Apress

Mastering Oracle SQL and SQL*Plus

  • Book
  • © 2005

Overview

Authors:
  1. Lex Haan
    View author publications

    You can also search for this author in PubMed   Google Scholar

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (12 chapters)

  1. Front Matter

    Pages i-xx
    Download chapter PDF

  2. Relational Database Systems and Oracle

    Pages 1-24

  3. Introduction to SQL, iSQL*Plus, and SQL*Plus

    Pages 25-64

  4. Data Definition, Part I

    Pages 65-75

  5. Retrieval: The Basics

    Pages 77-112

  6. Retrieval: Functions

    Pages 113-139

  7. Data Manipulation

    Pages 141-157

  8. Data Definition, Part II

    Pages 159-190

  9. Retrieval: Multiple Tables and Aggregation

    Pages 191-231

  10. Retrieval: Some Advanced Features

    Pages 233-263

  11. Views

    Pages 265-287

  12. SQL*Plus and iSQL*Plus

    Pages 289-325

  13. Object-Relational Features

    Pages 327-347

  14. Back Matter

    Pages 349-468
    Download chapter PDF
Back to top

Keywords

About this book

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.

About the author

Lex de Haan studied applied mathematics at the University of Technology in Delft, the Netherlands. His experience with Oracle goes back to the mid-1980s, version 4. He worked for Oracle Corporation from 1990 to 2004 in various education-related roles, ending up in Server Technologies (product development) as senior curriculum manager for the advanced database administration curriculum. In that role, he was involved in the development of Oracle9i and Oracle Database 10g. In March 2004, he decided to go independent and founded Natural Join B.V. (http://www.naturaljoin.nl). From 1999 until his passing in 2006, he was involved in the ISO SQL language standardization process, as a member of the Dutch national body. He was also one of the founding members of the OakTable network (http://www.oaktable.net).

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation