Mastering Oracle SQL and over one million other books are available for Amazon Kindle . Learn more

Quantity:


	Amazon Prime free trial required. Sign up when you check out. Learn more

More Buying Choices

Have one to sell? Sell yours here

Get a �4.05 Amazon.co.uk Gift Card

Share your own customer images

Search inside this book

Start reading Mastering Oracle SQL on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Mastering Oracle SQL: Putting Oracle SQL to Work. Covers Oracle Database 10g [Paperback]

Sanjay Mishra (Author), Alan Beaulieu (Author)

3.8 out of 5 stars See all reviews (4 customer reviews)

RRP:	�30.99
Price:	�23.86 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Deal Price:
You Save:	�7.13 (23%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 4 left in stock--order soon (more on the way).

Want guaranteed delivery by Saturday, June 2? Choose Express delivery at checkout. See Details

Formats	Amazon Price		New from	Used from
Kindle Edition	�16.82		--	--
Paperback	�23.86		--	--

Trade In this Item for up to �4.05

Get an extra �5 when you trade in books worth �10 or more until June 30, 2012. Trade in Mastering Oracle SQL: Putting Oracle SQL to Work. Covers Oracle Database 10g for an Amazon.co.uk gift card of up to �4.05, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.

› See more product promotions

Frequently Bought Together

Price For All Three: �78.49

Show availability and delivery details

Buy the selected items together

This item: Mastering Oracle SQL: Putting Oracle SQL to Work. Covers Oracle Database 10g by Sanjay Mishra Paperback �23.86

In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Oracle PL/SQL Programming by Steven Feuerstein Paperback �35.09

In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Oracle PL/SQL Best Practices by Steven Feuerstein Paperback �19.54

In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

Customers Who Bought This Item Also Bought

Oracle PL / SQL Programming by Steven Feuerstein
4.3 out of 5 stars (3)

�35.09
Oracle PL / SQL Best Practices by Steven Feuerstein
4.5 out of 5 stars (4)

�19.54
Oracle PL / SQL Language Pocket Reference (P... by Steven Feuerstein
4.2 out of 5 stars (5)

�8.05
Oracle SQL Tuning Pocket Reference by Mark Gurry
3.5 out of 5 stars (2)

�5.62
Learning SQL by Alan Beaulieu
4.4 out of 5 stars (5)

�20.14
OCA Oracle Database 11g SQL Fundamentals I Exam Gu... by John Watson
4.7 out of 5 stars (3)

�30.39

Product details

Paperback: 496 pages
Publisher: O'Reilly Media; 2 edition (29 Jun 2004)
Language English
ISBN-10: 0596006322
ISBN-13: 978-0596006327
Product Dimensions: 23.3 x 17.9 x 2.6 cm

Average Customer Review: 3.8 out of 5 stars See all reviews (4 customer reviews)

Amazon Bestsellers Rank: 231,311 in Books (See Top 100 in Books)

Would you like to update product info or give feedback on images?

See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Sanjay Mishra

Alan Beaulieu

Product Description

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.

From the Publisher

Updated to cover Oracle 10g, this new edition of the highly regarded Mastering Oracle SQL has a stronger focus on practical, expert best-practices and on Oracle-specific SQL technique than any other book on the market. 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.

See all Product Description

Inside This Book (Learn More)

Suggested Tags from Similar Products

(What's this?)

Be the first one to add a relevant tag (keyword that's strongly related to this product)

relational databases(3)

sql(3)

oracle(3)

postgresql(2)

database management systems(2)

database design(1)

database theory(1)

window functions(1)

database programming(1)

pl-sql(1)

What Other Items Do Customers Buy After Viewing This Item?

Oracle PL/SQL Programming by Steven Feuerstein Paperback
4.3 out of 5 stars (3)

�35.09

Oracle PL/SQL Best Practices by Steven Feuerstein Paperback
4.5 out of 5 stars (4)

�19.54

Oracle PL/SQL For Dummies by Michael Rosenblum Paperback
4.5 out of 5 stars (2)

�12.99

Oracle DBA Pocket Guide (Pocket Reference) by David C. Kreines Paperback
4.0 out of 5 stars (2)

�5.78

› Explore similar items

Customer Reviews

3 star

1 star

3.8 out of 5 stars

Write a customer review

Most Helpful Customer Reviews

9 of 9 people found the following review helpful

Good depth, assumes a lot 8 Dec 2004

By A Customer

Format:Paperback

I bought this book with the aim of extending my own use of SQL, which I have used for 10 years or more. I especially wanted to make more use of Oracle enhancements since I first used SQL. At first I wondered if I would get anything from the book, since it started off with explaining simple select/insert/update statements, but it very quickly got more in-depth. I found the depth to be excellent, but be warned if you are new to SQL: the writers very quickly start using technical terms without explanation, so if you're not already at least marginally confident with SQL, find a basics book first. I will be returning to this book repeatedly, it opened my eyes to so many more features that I'm dying to get to use!

Comment |

Was this review helpful to you?

Yes

1 of 1 people found the following review helpful

Learn the How not the What 19 Feb 2008

By mrjones64

Format:Paperback

This is an excellent addition to your SQL book library for the very simple reason it teaches you HOW to write SQL queries. Its not a SQL reference book in the sense it doesnt teach you what all the basic functions do, but it does teach you how to write quality SQL i.e. the concepts behinding writing SQL statements.

Comment |

Was this review helpful to you?

Yes

A Friendly Companion 18 Jun 2011

By EarlyDoors

Format:Paperback

Can I say what a great book this is. I am an oracle developer of 7 years experience who has spent the last three concentrating on object orientated Java development. As of two months ago I found myself back in the world of Oracle SQL for reporting and it dawned upon me how rusty I was with Oracle SQL. There have been great advances across 10 and 11g and unless you regularly work with advanced reporting functions it can be difficult to appreciate that it is possible to output varied data in one SQL statement rather than resorting to a logical breakup in PL/SQL. This book covers all depths, from what may appear to be too basic to extremely specialised and complex operations and is always well thought out and clearly explained.

Comment |

Was this review helpful to you?

Yes

› See all 4 customer reviews on Amazon.co.uk

Write a customer review

Would you like to see more reviews about this item?

› Go to Amazon.com to see all 14 reviews

Were these reviews helpful? Let us know

Most Recent Customer Reviews

Useful for newcomers - of little use to Oracle professionals

My main gripe with this book is the insistance of the authors (and Oracle for that matter) to force the new ANSI join down your throat, it is used in every single join with no... Read more

Published on 24 Jan 2005 by Sc0tty

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }