Apress Access

Beginning Oracle SQL

For Oracle Database 12c

3rd Edition

By Lex deHaan , Tim Gorman , Inger Jorgensen , Melanie Caffrey

  • eBook Price: $34.99
Buy eBook Buy Print Book
Beginning Oracle SQL introduces one of the most valuable dialects of SQL for any developer or database administrator to know.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-6556-6
  • 440 Pages
  • User Level: Beginner to Intermediate
  • Publication Date: March 11, 2014
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • Pro Application Lifecycle Management with Visual Studio 2012
  • Beginning ASP.NET 4.5 in C#
  • Expert PL/SQL Practices
  • Pro ASP.NET MVC 5 Platform
  • Managing Risk and Information Security
  • Pro Oracle Identity and Access Management Suite
  • Mastering Oracle GoldenGate
  • Oracle Application Express Administration
  • Expert Oracle Indexing and Access Paths, 2nd Edition
Full Description

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries.

Oracle's is possibly the most valuable dialect of SQL from a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements many features not found in competing products. No developer or DBA working with Oracle can afford to be without knowledge of these features and how they work, because of the performance and expressiveness they bring to the table.

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

What you’ll learn

  • Create database tables and define their relationships.
  • Add data to your tables. Then change and delete that data.
  • Write database queries that generate accurate results.
  • Avoid common traps and pitfalls in writing SQL queries, especially from nulls.
  • Reap the performance and expressiveness of analytic and window functions.
  • Make use of Oracle Database's support for object types.
  • Write recursive queries to query hierarchical data.

Who this book is for

Beginning Oracle SQL is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed.

Table of Contents

Table of Contents

1. Relational Database Systems and Oracle

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

3. Data Definition, Part I

4. Retrieval: The Basics

5. Retrieval: Functions

6. Data Manipulation

7. Data Definition, Part II

8. Retrieval: Joins and Grouping

9. Retrieval: Advanced Features


11. Automating

12. Object-Relational Features

13. Appendix A – Case Tables

14. Appendix B – Exercise Solutions

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.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. PHP Objects, Patterns, and Practice


      View Book

    2. Beginning Android 3D Game Development


      View Book

    3. Troubleshooting Oracle Performance


      View Book

    4. Beginning Amazon Web Services with Node.js


      View Book