Mastering Oracle SQL, 2nd Edition

Mastering Oracle SQL, 2nd Edition

Mastering Oracle SQL, 2nd Edition

  • ISBN13: 9780596006327
  • Condition: New
  • Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!

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.

List Price: $ 39.95

Price: [wpramaprice asin=”0596006322″]

[wpramareviews asin=”0596006322″]

Related Products

3 comments

  1. 19 of 20 people found the following review helpful
    4.0 out of 5 stars
    Helps you with 10g, July 22, 2004
    By 
    W Boudville (Terra, Sol 3) –
    (VINE VOICE)
      
    (TOP 1000 REVIEWER)
      
    (HALL OF FAME REVIEWER)
      

    This review is from: Mastering Oracle SQL, 2nd Edition (Paperback)
    [A REVIEW OF THE SECOND EDITION]

    Those of you dealing with the latest Oracle 10g, and perhaps frustrated with the quality of the Oracle documentation, might want to consult this second edition. Its greatest difference compared to the first edition is simply that it deals with 10g, whereas the latter talks about 9g. Mishra and Beaulieu explain, with extensive detail and examples, the new features. Like support for unix-like regular expressions within SQL statements. Given that many Oracle users probably hail from a unix/C background, they will welcome this.

    Also, for mapping between XML and SQL data types, 10g now integrates XML. This will reduce the impedance mismatch between the object oriented and relational outlooks that bedevil many programmers who have to deal with both.

    The only problem I found with this book is its lack of mention of competing databases. Because the authors explicitly assume that you have already committed to using Oracle as your database. Fair enough. But perhaps occasional comments in the text, about how a given command or feature is not possible in another database would be useful and appreciated by Oracle users. Heck, to be fair, on this point, the book is at no relative disadvantage. For example, I have texts on dB2 and MySQL that likewise say zilch about their competitors.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  2. 12 of 12 people found the following review helpful
    5.0 out of 5 stars
    Something for Everyone, March 15, 2003
    By 
    Tom Birch (BC. Canada) –

    This review is from: Mastering Oracle SQL (Paperback)
    This book presents complex stuctures in an easy to follow fashion with practical examples. I was able to apply new Oracle functions to real reporting problems immediately after reading it.
    If you ever have written a PL/SQL function purely to manipulate data because you didn’t think SQL would be able to do it, you need to read this book!
    The book covers the spectrum from basics to the new 9i analytical functions. As such anyone can benefit from it.
    The book is written to help the user understand the power of well structured SQL. It does not contain an exhaustive syntactical list (which can be easily found elsewhere) but rather outlines how to acually use SQL to achieve solid results and optimal performance. In my experience, a high percentage of users who think they know how to write good SQL, actually only know a lot of low-level syntax and are in need of the big picture this book provides.
    The chapter on Dates however, does go into fascinating and exhaustive detail of the date data type structure, both pre-existing and Oracle 9i. This is an absolute must for anyone who works with a database that contains highly time sensative data, or for those who are confused by the data type.
    The new features in Oracle 9i are clearly outlined such as the reporting functions for grouping at multiple levels. This book presents them in a way that opens the user’s mind to endless possiblities, leaving the reader wondering how they every managed without them (or how they will manage without them until their company’s next upgrade).

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  3. 15 of 16 people found the following review helpful
    4.0 out of 5 stars
    Good overview of Basic DML & advanced features, December 22, 2004
    By 
    An average joe “rm” (Reno, NV) –

    This review is from: Mastering Oracle SQL, 2nd Edition (Paperback)
    I will agree with other reviewers that cite this book as an excellent resource. It is well organized and easy to follow from topic to topic without getting lost. The examples are well introduced and written with few minor errors. These will be easy to spot for someone who has used any flavor of SQL.

    Some issues that I did have with the book revolve around what it isn’t. Most of the book revolves around features that are new to 10g rather than a solid overview of the Oracle DML. This means that readers will not be properly introduced to string manipulation outside of the regular expression implementation which is new to 10g (Legacy DBs?). Also, you will have to look elsewhere for good information on CAST, CONVERT and case changing functions. These can be crucial as Oracle is much more strongly typed with regards to data than MS SQL Server.

    As DBAs or reporting analysts aren’t always privy to the latest release, I see the concentration on 10g’s new features as a flaw. Over all this book will introduce you to Oracle SQL in an easy to follow manner. Experienced SQL users will be able to become functional by using this book but, will scratch their heads when they encounter the DML language gaps.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

Leave a Reply

Your email address will not be published. Required fields are marked *