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.
$19.89 List price: $31.99 You save: 38% ($12.10)
If you use one of Kobo's free reading apps you won't need to worry about download options most of the time. Your Kobo reading app can easily add Kobo Store books to your library for a seamless reading experience.
Download options matter when:
In both of these cases you will need to:
You can also use Digital Editions to transfer the book to your eReader. See here for more information on Digital Editions.
You can read this item on your computer using our free Kobo Desktop Application. This application lets you read, manage your library of eBooks, and even shop for new ones. Check out our demo for more information!
Learn More »You can read this item on your Kobo eReader (or other select electronic reading devices). The Kobo eReader lets you carry your whole library with you, so that you can read on the go.
Visit kobo.com/ereaders »You can read this item on select tablets using one of our free Kobo apps. These apps let you read, manage your library of eBooks, and even shop for new ones.
Learn More »You can read this item on your Kobo Arc using the Library app. This app lets you read, manage your library of eBooks, and shop for new books.
Learn More »You can read this item on any Android device (phone, tablet) with one of our free Kobo apps. These apps let you read, manage your library of eBooks, and even shop for new ones.
Learn More »You can read this item on the free Kobo app for iPhone. This app let you read, manage your library of eBooks, and even shop for new ones.
Download the iPhone App! Learn More »
By: {2}
Available on: {3}
Coming soon
Secure TransactionSubtotal
Store Credit
Total
We'll charge your credit card {4} on {3}.
We'll charge your credit card {4} when the book is added to your Library.
Your store credit covers the cost of this purchase, so we don't charge your credit card
Use Quick Buy for all eBook purchases.{2} is now in your library. You'll receive an email confirming your purchase very soon.
{2} has been pre-ordered. You'll receive a confirmation email confirming your pre-order very soon.
You were charged:
You will be charged: on {3}
You will be charged: when the book is added to your Library
Rakuten Super Points earned: {1}
Rakuten Super Points {1} earned after the book is added to your Library
