Brain Candy Sale

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    The Powell's Playlist | September 25, 2015

    Caitlin Doughty: IMG Caitlin Doughty's Playlist for Smoke Gets in Your Eyes

    The soundtrack perfectly suited to facing your own mortality. ("My Way," "Wind beneath My Wings," and other popular funeral songs need not apply.)... Continue »
    1. $11.17 Sale Trade Paper add to wish list

Qualifying orders ship free.
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Database- Design

Mastering Oracle SQL 2ND Edition


Mastering Oracle SQL 2ND Edition Cover


Synopses & Reviews

Publisher Comments:

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

Book News Annotation:

Covering Oracle SQL's main features, including the new features of Oracle Database 10g, this guide uses real-world examples to show how to use Oracle to solve specific problems or meet particular needs. The book gives specific attention to Oracle's strengths in the areas of regular expressions, interior calculations, recursive queries, analytic and advanced Group BY functions, and SQL/XML standards.
Annotation 2004 Book News, Inc., Portland, OR (


- Updated to cover the latest version of Oracle, Oracle 10g
- Includes a unified example dataset that ensures the data underlying the examples do not differ from chapter to chapter
- Features stronger focus on technique and on Oracle's implementation of SQL than any other book on the market

About the Author

Sanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. He has been involved in the design, architecture, and implementation of many mission-critical and decision support databases. He has worked extensively in the areas of database architecture, database management, backup / recovery, performance tuning, Oracle Parallel Server, and parallel execution. He has a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the coauthor of Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly & Associates). Presently, he works as a database architect at Dallas Based i2 Technologies, and can be reached at

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at

Table of Contents

PrefaceChapter 1: Introduction to SQLChapter 2: The WHERE ClauseChapter 3: JoinsChapter 4: Group OperationsChapter 5: SubqueriesChapter 6: Handling Temporal DataChapter 7: Set OperationsChapter 8: Hierarchical QueriesChapter 9: DECODE and CASEChapter 10: PartitioningChapter 11: PL/SQLChapter 12: Objects and CollectionsChapter 13: Advanced Group OperationsChapter 14: Advanced Analytic SQLChapter 15: SQL Best PracticesChapter 16: XMLChapter 17: Regular ExpressionsChapter 18: Model QueriesAppendix A: Oracle's Old Join SyntaxColophon

Product Details

Mishra, Sanjay
O'Reilly Media
Beaulieu, Alan
Database Management - Oracle
Sql (computer program language)
Database Management - General
Database design
oracle 10g;oracle dba;oracle sql;sql
Programming Languages - SQL
CourseSmart Subject Description
Edition Number:
Edition Description:
Second Edition
Publication Date:
9.1 x 7 x 1.1 in 1.73 lb

Other books you might like

  1. Oracle Essentials 3RD Edition Oracle 10G Used Trade Paper $16.50
  2. A Short History of Nearly Everything
    Used Trade Paper $8.50
  3. Wooden Boats: In Pursuit of the... Used Trade Paper $5.95
  4. JavaServer Faces in Action (In... New Trade Paper $49.95
  5. Defining the Wind: The Beaufort... Used Hardcover $2.98

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Mastering Oracle SQL 2ND Edition New Trade Paper
0 stars - 0 reviews
$39.95 In Stock
Product details 496 pages O'Reilly & Associates - English 9780596006327 Reviews:
"Synopsis" by , - Updated to cover the latest version of Oracle, Oracle 10g
- Includes a unified example dataset that ensures the data underlying the examples do not differ from chapter to chapter
- Features stronger focus on technique and on Oracle's implementation of SQL than any other book on the market
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at