Skip to Main Content
Mastering Oracle SQL
book

Mastering Oracle SQL

by Sanjay Mishra, Alan Beaulieu
April 2002
Intermediate to advanced content levelIntermediate to advanced
336 pages
9h 58m
English
O'Reilly Media, Inc.
Content preview from Mastering Oracle SQL

Structure of This Book

This book is divided into 14 chapters:

  • Chapter 1 introduces the SQL language and describes its brief history. This chapter is primarily for those readers who have little or no prior SQL experience. You’ll find simple examples of the core SQL statements (SELECT, INSERT, UPDATE, and DELETE) and of SQL’s basic features.

  • Chapter 2 describes ways to filter data in your SQL statements. You’ll learn to restrict the results of a query to the rows you wish to see, and restrict the results of a data manipulation statement to the rows you wish to modify.

  • Chapter 3 describes constructs used to access data from multiple, related tables. The important concepts of inner join and outer join are discussed in this chapter. The new ANSI-compliant join syntax introduced in Oracle9i is also discussed.

  • Chapter 4 shows you how to generate summary information, such as totals and subtotals, from your data. Learn how to define groups of rows, and how to apply various aggregate functions to summarize data in those groups.

  • Chapter 5 shows you how to use correlated and noncorrelated subqueries and inline views to solve complex problems that would otherwise require procedural code together with more than one query.

  • Chapter 6 talks about handling date and time information in an Oracle database. Learn the tricks and traps of querying time-based data. Also learn about Oracle9i’s many new date and time datatypes.

  • Chapter 7 shows you how to use UNION, INTERSECT, and MINUS to combine results ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle SQL

Oracle SQL

Dan Hotka
Oracle SQL Developer

Oracle SQL Developer

Ajith Narayanan, Susan Harper

Publisher Resources

ISBN: 0596001290Supplemental ContentCatalog PageErrata