{"product_id":"mastering-oracle-sql-9780596006327","title":"Mastering Oracle SQL","description":"\u003cp\u003eThe 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 \u003ci\u003eMastering Oracle SQL\u003c\/i\u003e 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.\u003ci\u003eMastering Oracle SQL\u003c\/i\u003e, 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.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e O'Reilly Media\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 07\/06\/2004\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9780596006327\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 472\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 1.75lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.10h x 7.00w x 1.10d\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003eReview Citations: \u003c\/strong\u003e\u003ci\u003eScitech Book News\u003c\/i\u003e 12\/01\/2004 pg. 22\u003cbr\u003e","brand":"Sanjay Mishra, Alan Beaulieu","offers":[{"title":"Default Title","offer_id":36639256838300,"sku":"9780596006327","price":42.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/products\/img_bc555393-2931-4577-8b36-0c054d37d029.jpg?v=1603849346","url":"https:\/\/pastforward.org\/products\/mastering-oracle-sql-9780596006327","provider":"Past Forward","version":"1.0","type":"link"}