Skip to main content
  • Book
  • © 2010

Beginning Oracle SQL

Apress

Authors:

  • 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

Buy it now

Buying options

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

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

Table of contents (12 chapters)

  1. Front Matter

    Pages i-xxiii
  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

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

Buy it now

Buying options

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