Skip to main content
SpringerLink
Log in
Apress
Book cover

Beginning Oracle SQL

  • Book
  • © 2010

Overview

Authors:
  1. Lex Haan
    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Daniel Fink
    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Tim Gorman
    View author publications

    You can also search for this author in PubMed   Google Scholar

  4. Inger Jørgensen
    View author publications

    You can also search for this author in PubMed   Google Scholar

  5. Karen Morton
    View author publications

    You can also search for this author in PubMed   Google Scholar

Editors:
  1. Jonathan Gennick
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  2. Clay Andres
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  3. Steve Anglin
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  4. Mark Beckner
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  5. Ewan Buckingham
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  6. Gary Cornell
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  7. Jonathan Hassell
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  8. Michelle Lowman
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  9. Matthew Moodie
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  10. Duncan Parkes
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  11. Jeffrey Pepper
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  12. Frank Pohlmann
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  13. Douglas Pundick
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  14. Ben Renow-Clarke
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  15. Dominic Shakeshaft
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  16. Mat Wade
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  17. Tom Welsh
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  18. Jim Markham
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  19. Seth Kline
    View editor publications

    You can also search for this editor in PubMed   Google Scholar

  • Carries the endorsement of the OakTable Network, a highly-regarded, invitation-only, international group of experts on Oracle Database

  • Coauthored by an expert who spent many years working at Oracle, who also was part of the international standards committee that designed the SQL language

  • Now forms part of Apress's core roadmap for readers of Oracle Database topics

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 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 44.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-xxiii
    Download chapter PDF

  2. Relational Database Systems and Oracle

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 1-24

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

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 25-69

  4. Data Definition, Part I

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 71-81

  5. Retrieval: The Basics

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 83-116

  6. Retrieval: Functions

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 117-144

  7. Data Manipulation

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 145-161

  8. Data Definition, Part II

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 163-193

  9. Retrieval: Multiple Tables and Aggregation

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 195-232

  10. Retrieval: Some Advanced Features

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 233-264

  11. Views

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 265-286

  12. Writing and Automating SQL *Plus Scripts

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 287-327

  13. Object-Relational Features

    • Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
    Pages 329-347

  14. Back Matter

    Pages 349-423
    Download chapter PDF
Back to top

About this book

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover developments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle database.

  • Takes an example-based approach, with clear and authoritative explanations
  • Introduces both SQL and the query tools used to execute SQL statements
  • Shows how to create tables, populate them with data, and then query that data to generate business results

About the authors

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

  • Book Title: Beginning Oracle SQL

  • Authors: Lex Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton

  • Editors: Jonathan Gennick, Clay Andres, Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell, Jonathan Hassell, Michelle Lowman, Matthew Moodie, Duncan Parkes, Jeffrey Pepper, Frank Pohlmann, Douglas Pundick, Ben Renow-Clarke, Dominic Shakeshaft, Mat Wade, Tom Welsh, Jim Markham, … Seth Kline

  • DOI: https://doi.org/10.1007/978-1-4302-7196-3

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books

  • Copyright Information: Lex deHaan and Karen Morton and Tim Gorman and Inger Jorgensen and Daniel Fink and Andrew Morton 2010

  • Softcover ISBN: 978-1-4302-7197-0Published: 17 December 2009

  • eBook ISBN: 978-1-4302-7196-3Published: 28 January 2011

  • Edition Number: 1

  • Number of Pages: 459

  • Topics: Database Management, Data Structures and Information Theory

Publish with us

Policies and ethics

Back to top

Search

Navigation