{"product_id":"mastering-oracle-sql-sanjay-mishra-9780596006327","title":"Mastering Oracle SQL","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 \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.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Sanjay Mishra, Alan Beaulieu\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 0596006322\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9780596006327\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e O'Reilly Media\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 07\/27\/2004\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 494\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\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\u003cb\u003eReview Citation(s): \u003c\/b\u003e\u003cbr\u003e\u003ci\u003eScitech Book News\u003c\/i\u003e 12\/01\/2004 pg. 22","brand":"Sanjay Mishra","offers":[{"title":"Paperback","offer_id":43946830070015,"sku":"9780596006327","price":49.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/products\/img_04f8dd6a-8ada-48e3-9171-7463197806fe.jpg?v=1681515359","url":"https:\/\/www.whiterainbookhouse.com\/products\/mastering-oracle-sql-sanjay-mishra-9780596006327","provider":"WR Book House","version":"1.0","type":"link"}