{"product_id":"oracle-sql-plus-pocket-reference-paperback-1","title":"Oracle SQL Plus Pocket Reference - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eJonathan Gennick\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003eThe \u003ci\u003eOracle SQL*Plus Pocket Reference\u003c\/i\u003e is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQL*Plus. As Oracle's long-standing interactive query tool, SQL*Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL*Plus is still often not completely understood or fully utilized. Database administrators and developers alike will therefore find the \u003ci\u003eOracle SQL*Plus Pocket Reference\u003c\/i\u003e to be extremely beneficial. In addition to summarizing all of the SQL*Plus syntax and format options, including new Oracle Database 10\u003ci\u003eg\u003c\/i\u003e features, this handy, on-the-job guide specifically shows readers how to: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDifferentiate between SQL and SQL*Plus \u003c\/li\u003e\n\u003cli\u003eInteract with SQL*Plus from both the command line and the web browser \u003c\/li\u003e\n\u003cli\u003eSelect, insert, update, and delete data \u003c\/li\u003e\n\u003cli\u003eFormat both text and HTML reports with SQL*Plus \u003c\/li\u003e\n\u003cli\u003eSpecify SQL*Plus commands and format elements \u003c\/li\u003e\n\u003cli\u003eTune SQL queries\u003c\/li\u003e\n\u003c\/ul\u003e The new third edition of this book has been updated for Oracle Database 10\u003ci\u003eg\u003c\/i\u003e to include information on both SQL*Plus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN. With its quick-reference format and compact size, the \u003ci\u003eOracle SQL*Plus Pocket Reference\u003c\/i\u003e follows in the long line of successful \"pocket references\" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQL*Plus, the bestselling \u003ci\u003eOracle SQL*Plus: The Definitive Guide\u003c\/i\u003e. Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eJonathan Gennick is an O'Reilly Media, Inc. editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management.\u003cbr\u003e\u003cbr\u003eJonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities.\u003cbr\u003e\u003cbr\u003eIn 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQL\u003cem\u003eLoader (O'Reilly Media, Inc., 2001); Oracle SQL\u003c\/em\u003ePlus Pocket Reference (O'Reilly Media, Inc., 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly Media, Inc., 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly Media, Inc., 2002) and editing Practical PostgreSQL (O'Reilly Media, Inc., 2002).\u003cbr\u003e\u003cbr\u003eJonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http: \/\/gennick.com.\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 146\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.43 x 6.96 x 4.36 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e December 21, 2004\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47211996840185,"sku":"9780596008857","price":14.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/SnJORTUwb2d2YTRYajlCZmp0eTdKZz09_2fcecbe4-8cfc-40a6-b807-40ab79bb6224.webp?v=1768087814","url":"https:\/\/bookscloud.io\/products\/oracle-sql-plus-pocket-reference-paperback-1","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}